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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for