Share via


DataLabelsRange class

Defines the DataLabelsRange Class.This class is only available in O15. When the object is serialized out as xml, its qualified name is c15:datalabelsRange.

Inheritance hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office15.Drawing.Chart.DataLabelsRange

Namespace:  DocumentFormat.OpenXml.Office15.Drawing.Chart
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(DataLabelsRangeChache), FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(Formula), FileFormatVersions.Office15)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office15)> _
Public Class DataLabelsRange _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As DataLabelsRange
[ChildElementInfoAttribute(typeof(DataLabelsRangeChache), FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(Formula), FileFormatVersions.Office15)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office15)]
public class DataLabelsRange : OpenXmlCompositeElement

Remarks

2.3.55 datalabelsRange

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

datalabelsRange is a CT_SeriesDataLabelsRange element that specifies the reference to the formula from which the values of datalabels ([MS-ODRAWXML] section 2.5.162) 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.14 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.5.100 CT_SeriesDataLabelsRange

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

Referenced by: datalabelsRange

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.

Child Elements:

f: It is a string ([XMLSCHEMA2] section 3.2.1) element that specifies the reference 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.

dlblRangeCache: It is a CT_StrData ([MS-ODRAWXML] section 2.5.127) element that contains the values to be inserted in each of the datalabels (section 2.2.1.3) 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.14 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Thread safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See also

Reference

DataLabelsRange members

DocumentFormat.OpenXml.Office15.Drawing.Chart namespace