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.
You should access and use this enumeration from the Excel primary interop assembly (PIA). Indicates the position of data labels relative to the data markers.
public enum class XlDataLabelPositionpublic enum XlDataLabelPositiontype XlDataLabelPosition = Public Enum XlDataLabelPosition- Inheritance
-
XlDataLabelPosition
Fields
| Name | Value | Description |
|---|---|---|
| xlLabelPositionRight | -4152 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned at top of bar or pie. |
| xlLabelPositionLeft | -4131 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned at bottom of bar or pie. |
| xlLabelPositionCenter | -4108 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label centered on data point or inside bar or pie. |
| xlLabelPositionAbove | 0 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned above point. |
| xlLabelPositionBelow | 1 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned below point. |
| xlLabelPositionOutsideEnd | 2 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned at top of bar or pie. |
| xlLabelPositionInsideEnd | 3 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned arbitrarily. |
| xlLabelPositionInsideBase | 4 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned arbitrarily. |
| xlLabelPositionBestFit | 5 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Office application controls position of data label. |
| xlLabelPositionMixed | 6 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned at bottom of bar or pie. |
| xlLabelPositionCustom | 7 | You should access and use this enumeration from the Excel primary interop assembly (PIA). Data label centered on data point or inside bar or pie. |