xlDataLabelPosition

Specifies where the data label is positioned.

xlLabelPositionAboveData label above point (0)
xlLabelPositionBelowData label below point (1)
xlLabelPositionBestFitExcel controls position of data label (5)
xlLabelPositionCenterData label centered on data point or inside bar or pie (-4108)
xlLabelPositionCustomData label centered on data point or inside bar or pie (7)
xlLabelPositionInsideBaseData label positioned arbitrarily (4)
xlLabelPositionInsideEndData label positioned at the left of bar or pie (3)
xlLabelPositionLeftData label positioned at the left of bar or pie (-4131)
xlLabelPositionMixed(6)
xlLabelPositionOutsideEnd(2)
xlLabelPositionRightData label positioned at the right of bar or pie (-4152)

xlLabelPositionAbove
Data label above point (0)
xlLabelPositionBelow
Data label below point (1)
xlLabelPositionBestFit
Excel controls position of data label (5)
xlLabelPositionCenter
Data label centered on data point or inside bar or pie (-4108)
xlLabelPositionCustom
Data label centered on data point or inside bar or pie (7)
xlLabelPositionInsideBase
Data label positioned arbitrarily (4)
xlLabelPositionInsideEnd
Data label positioned at the left of bar or pie (3)
xlLabelPositionLeft
Data label positioned at the left of bar or pie (-4131)
xlLabelPositionMixed
(6)
xlLabelPositionOutsideEnd
(2)
xlLabelPositionRight
Data label positioned at the right of bar or pie (-4152)

REMARKS
* Every chart type has a different distinct list of possible label positions.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top