XlDataLabelPosition enumeration (Excel)
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. |
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.