DataLabelsRange class

2.3.55 datalabelsRange

Target namespace: http://schemas.microsoft.com/office/drawing/2012/chart

datalabelsRange is a CT_SeriesDataLabelsRange element<115> that specifies the reference to the formula from which the values of dLbls element ([ISO/IEC-29500-1] section 21.2.2.49) on a chart series ([ISO/IEC-29500-1] section 21.2) are obtained.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="datalabelsRange" type="CT_SeriesDataLabelsRange"/>

See section 5.13 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.5.97 CT_SeriesDataLabelsRange

Target namespace: http://schemas.microsoft.com/office/drawing/2012/chart

Referenced by: datalabelsRange

The CT_SeriesDataLabelsRange is a complex type that specifies the formula from which the values of the Datalabels (section 2.2.1.3) on a chart series ([ISO/IEC-29500-1] section 21.2) are obtained.<158>

Child Elements:

f: It is a string ([XMLSCHEMA2] section 3.2.1) element that specifies the reference from which the values of the Datalabels on a chart series ([ISO/IEC-29500-1] section 21.2) are obtained. This reference MUST follow the ABNF grammar rules defined in the Formulas section ([MS-XLSX] section 2.2.2) with the following restrictions:

MUST follow the single-sheet-reference rule OR the external-name rule.

MUST NOT use the A1-relative-column and A1-relative-row rules. MUST use ONLY A1-absolute-column and A1-absolute-row

MUST NOT use the bang-name rule.

If the string contains a "#REF!", it MUST be the ONLY value in the string.

dlblRangeCache: It is a CT_StrData ([ISO/IEC-29500-1] section A.5.1) element that contains the values to be inserted in each of the Datalabels in the parent chart series ([ISO/IEC-29500-1] section 21.2). This is a cache of values obtained from the reference formula specified by the element f in this complex type. Each value corresponds to one Datalabel in the series. The values are assigned to Datalabels in the order of their index.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_SeriesDataLabelsRange">

<xsd:sequence>

<xsd:element name="f" type="xsd:string" minOccurs="1" maxOccurs="1"/>

<xsd:element name="dlblRangeCache" type="c:CT_StrData" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

</xsd:complexType>

See section 5.13 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Reference