Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
XlDataLabelsType Enumeration
Collapse the table of content
Expand the table of content

XlDataLabelsType Enumeration

Specifies the type of data label to apply. The default is typically xlDataLabelsShowValue.

Namespace:  Microsoft.Office.Core
Assembly:  office (in office.dll)

public enum XlDataLabelsType

Member nameDescription
xlDataLabelsShowNoneNo data labels.
xlDataLabelsShowValueValue for the point (assumed if this argument isn't specified).
xlDataLabelsShowPercentPercentage of the total. Available only for pie charts and doughnut charts.
xlDataLabelsShowLabelCategory for the point.
xlDataLabelsShowLabelAndPercentPercentage of the total, and category for the point. Available only for pie charts and doughnut charts.
xlDataLabelsShowBubbleSizesShow the size of the bubble in reference to the absolute value.
© 2015 Microsoft