XlDataLabelPosition enumeration (Office)
Indicates the position of data labels relative to the data markers.
Name | Value | Description |
---|---|---|
xlLabelPositionAbove | 0 | Data label positioned above point. |
xlLabelPositionBelow | 1 | Data label positioned below point. |
xlLabelPositionBestFit | 5 | Office application controls position of data label. |
xlLabelPositionCenter | -4108 | Data label centered on data point or inside bar or pie. |
xlLabelPositionCustom | 7 | Data label centered on data point or inside bar or pie. |
xlLabelPositionInsideBase | 4 | Data label positioned arbitrarily. |
xlLabelPositionInsideEnd | 3 | Data label positioned arbitrarily. |
xlLabelPositionLeft | -4131 | Data label positioned at bottom of bar or pie. |
xlLabelPositionMixed | 6 | Data label positioned at bottom of bar or pie. |
xlLabelPositionOutsideEnd | 2 | Data label positioned at top of bar or pie. |
xlLabelPositionRight | -4152 | Data label positioned at top of bar or pie. |
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.