XlDataLabelPosition enumeration (Excel)
Specifies where the data label is positioned.
| Name | Value | Description |
|---|---|---|
| xlLabelPositionAbove | 0 | Data label is positioned above the data point. |
| xlLabelPositionBelow | 1 | Data label is positioned below the data point. |
| xlLabelPositionBestFit | 5 | Microsoft Office Excel 2007 sets the position of the data label. |
| xlLabelPositionCenter | -4108 | Data label is centered on the data point or is inside a bar or pie chart. |
| xlLabelPositionCustom | 7 | Data label is in a custom position. |
| xlLabelPositionInsideBase | 4 | Data label is positioned inside the data point at the bottom edge. |
| xlLabelPositionInsideEnd | 3 | Data label is positioned inside the data point at the top edge. |
| xlLabelPositionLeft | -4131 | Data label is positioned to the left of the data point. |
| xlLabelPositionMixed | 6 | Data labels are in multiple positions. |
| xlLabelPositionOutsideEnd | 2 | Data label is positioned outside the data point at the top edge. |
| xlLabelPositionRight | -4152 | Data label is positioned to the right of the data point. |
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