Share via


XlDataLabelsType Enumeration

Excel Developer Reference

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).