XlDataLabelPosition Enumeration
| Excel Developer Reference |
|
Specifies where the data label is positioned.
| 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. |