XlDataLabelPosition Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies where the data label is positioned.
public enum class XlDataLabelPositionpublic enum XlDataLabelPositiontype XlDataLabelPosition = Public Enum XlDataLabelPosition- Inheritance
-
XlDataLabelPosition
Fields
| Name | Value | Description |
|---|---|---|
| xlLabelPositionRight | -4152 | Data label is positioned to the right of the data point. |
| xlLabelPositionLeft | -4131 | Data label is positioned to the left of the data point. |
| xlLabelPositionCenter | -4108 | Data label is centered on the data point or is inside a bar or pie chart. |
| xlLabelPositionAbove | 0 | Data label is positioned above the data point. |
| xlLabelPositionBelow | 1 | Data label is positioned below the data point. |
| xlLabelPositionOutsideEnd | 2 | Data label is positioned outside the data point at the top edge. |
| xlLabelPositionInsideEnd | 3 | Data label is positioned inside the data point at the top edge. |
| xlLabelPositionInsideBase | 4 | Data label is positioned inside the data point at the bottom edge. |
| xlLabelPositionBestFit | 5 | 1st_Word12 sets the position of the data label. |
| xlLabelPositionMixed | 6 | Data labels are in multiple positions. |
| xlLabelPositionCustom | 7 | Data label is in a custom position. |