XlDataLabelsType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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: