XlDataLabelPosition Enumeration
Specifies where the data label is positioned.
Name |
Value |
Description |
|---|---|---|
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. |