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 XlDataLabelPositionPublic Enum XlDataLabelPosition- Inheritance
-
XlDataLabelPosition
Fields
| Name | Value | Description |
|---|---|---|
| xlLabelPositionRight | -4152 | Data label positioned at top of bar or pie. |
| xlLabelPositionLeft | -4131 | Data label positioned at bottom of bar or pie. |
| xlLabelPositionCenter | -4108 | Data label centered on data point or inside bar or pie. |
| xlLabelPositionAbove | 0 | Data label above point. |
| xlLabelPositionBelow | 1 | Data label below point. |
| xlLabelPositionOutsideEnd | 2 | Data label positioned at top of bar or pie. |
| xlLabelPositionInsideEnd | 3 | Data label positioned arbitrarily. |
| xlLabelPositionInsideBase | 4 | Data label positioned arbitrarily. |
| xlLabelPositionBestFit | 5 | Excel controls position of data label. |
| xlLabelPositionMixed | 6 | Data label positioned at bottom of bar or pie. |
| xlLabelPositionCustom | 7 | Data label centered on data point or inside bar or pie. |