Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

XlDataLabelsType Enumeration

Specifies the type of data label to apply.

Name

Value

Description

xlDataLabelsShowBubbleSizes

6

Show the size of the bubble in reference to the absolute value.

xlDataLabelsShowLabel

4

Category for the point.

xlDataLabelsShowLabelAndPercent

5

Percentage of the total, and category for the point. Available only for pie charts and doughnut charts.

xlDataLabelsShowNone

-4142

No data labels.

xlDataLabelsShowPercent

3

Percentage of the total. Available only for pie charts and doughnut charts.

xlDataLabelsShowValue

2

Default value for the point (assumed if this argument is not specified).

Show:
© 2015 Microsoft