XlDataLabelsType enumeration (Excel)
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). |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.