XlDataLabelsType Enumeration
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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:
© 2016 Microsoft