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). |
Support and feedback
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.