xlDataLabelPosition |
Specifies where the data label is positioned. |
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 | Mixed position (6) |
xlLabelPositionOutsideEnd | Position outside the end (2) |
xlLabelPositionRight | Data 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 |
Mixed position (6) |
xlLabelPositionOutsideEnd |
Position outside the end (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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top