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.