DataLabels Class

Data Labels.When the object is serialized out as xml, its qualified name is c:dLbls.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Drawing.Charts.DataLabels

Namespace:  DocumentFormat.OpenXml.Drawing.Charts
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(Delete))> _
<ChildElementInfoAttribute(GetType(DataLabel))> _
<ChildElementInfoAttribute(GetType(NumberingFormat))> _
<ChildElementInfoAttribute(GetType(ChartShapeProperties))> _
<ChildElementInfoAttribute(GetType(TextProperties))> _
<ChildElementInfoAttribute(GetType(DataLabelPosition))> _
<ChildElementInfoAttribute(GetType(ShowLegendKey))> _
<ChildElementInfoAttribute(GetType(ShowValue))> _
<ChildElementInfoAttribute(GetType(ShowCategoryName))> _
<ChildElementInfoAttribute(GetType(ShowSeriesName))> _
<ChildElementInfoAttribute(GetType(ShowPercent))> _
<ChildElementInfoAttribute(GetType(ShowBubbleSize))> _
<ChildElementInfoAttribute(GetType(Separator))> _
<ChildElementInfoAttribute(GetType(ShowLeaderLines))> _
<ChildElementInfoAttribute(GetType(LeaderLines))> _
<ChildElementInfoAttribute(GetType(ExtensionList))> _
Public Class DataLabels _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As DataLabels
[ChildElementInfoAttribute(typeof(Delete))]
[ChildElementInfoAttribute(typeof(DataLabel))]
[ChildElementInfoAttribute(typeof(NumberingFormat))]
[ChildElementInfoAttribute(typeof(ChartShapeProperties))]
[ChildElementInfoAttribute(typeof(TextProperties))]
[ChildElementInfoAttribute(typeof(DataLabelPosition))]
[ChildElementInfoAttribute(typeof(ShowLegendKey))]
[ChildElementInfoAttribute(typeof(ShowValue))]
[ChildElementInfoAttribute(typeof(ShowCategoryName))]
[ChildElementInfoAttribute(typeof(ShowSeriesName))]
[ChildElementInfoAttribute(typeof(ShowPercent))]
[ChildElementInfoAttribute(typeof(ShowBubbleSize))]
[ChildElementInfoAttribute(typeof(Separator))]
[ChildElementInfoAttribute(typeof(ShowLeaderLines))]
[ChildElementInfoAttribute(typeof(LeaderLines))]
[ChildElementInfoAttribute(typeof(ExtensionList))]
public class DataLabels : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • DataLabel <c:dLbl>

  • Delete <c:delete>

  • NumberingFormat <c:numFmt>

  • ChartShapeProperties <c:spPr>

  • TextProperties <c:txPr>

  • DataLabelPosition <c:dLblPos>

  • ShowLegendKey <c:showLegendKey>

  • ShowValue <c:showVal>

  • ShowCategoryName <c:showCatName>

  • ShowSeriesName <c:showSerName>

  • ShowPercent <c:showPercent>

  • ShowBubbleSize <c:showBubbleSize>

  • Separator <c:separator>

  • ShowLeaderLines <c:showLeaderLines>

  • LeaderLines <c:leaderLines>

  • ExtensionList <c:extLst>

[ISO/IEC 29500-1 1st Edition]

21.2.2.49 dLbls (Data Labels)

This element serves as a root element that specifies the settings for the data labels for an entire series or the entire chart. It contains child elements that specify the specific formatting and positioning settings.

Parent Elements

area3DChart (§21.2.2.4); areaChart (§21.2.2.5); bar3DChart (§21.2.2.15); barChart (§21.2.2.16); bubbleChart (§21.2.2.20); doughnutChart (§21.2.2.50); line3DChart (§21.2.2.96); lineChart (§21.2.2.97); ofPieChart (§21.2.2.126); pie3DChart (§21.2.2.140); pieChart (§21.2.2.141); radarChart (§21.2.2.153); scatterChart (§21.2.2.161); ser (§21.2.2.168); ser (§21.2.2.170); ser (§21.2.2.174); ser (§21.2.2.171); ser (§21.2.2.172); ser (§21.2.2.169); ser (§21.2.2.167); stockChart (§21.2.2.198)

Child Elements

Subclause

delete (Delete)

§21.2.2.40

dLbl (Data Label)

§21.2.2.47

dLblPos (Data Label Position)

§21.2.2.48

extLst (Chart Extensibility)

§21.2.2.64

leaderLines (Leader Lines)

§21.2.2.92

numFmt (Number Format)

§21.2.2.121

separator (Separator)

§21.2.2.166

showBubbleSize (Show Bubble Size)

§21.2.2.178

showCatName (Show Category Name)

§21.2.2.179

showLeaderLines (Show Leader Lines)

§21.2.2.183

showLegendKey (Show Legend Key)

§21.2.2.184

showPercent (Show Percent)

§21.2.2.187

showSerName (Show Series Name)

§21.2.2.188

showVal (Show Value)

§21.2.2.189

spPr (Shape Properties)

§21.2.2.197

txPr (Text Properties)

§21.2.2.216

[Note: The W3C XML Schema definition of this element’s content model (CT_DLbls) is located in §A.5.1. end note]

© ISO/IEC29500: 2008.

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

DataLabels Members

DocumentFormat.OpenXml.Drawing.Charts Namespace