XlDataLabelPosition enumeration

Office 2013 and later

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.

Namespace:  Microsoft.Office.Core
Assembly:  office (in office.dll)

No code example is currently available or this language may not be supported.

Member nameDescription
xlLabelPositionCenterYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label centered on data point or inside bar or pie.
xlLabelPositionAboveYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned above point.
xlLabelPositionBelowYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned below point.
xlLabelPositionLeftYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned at bottom of bar or pie.
xlLabelPositionRightYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned at top of bar or pie.
xlLabelPositionOutsideEndYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned at top of bar or pie.
xlLabelPositionInsideEndYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned arbitrarily.
xlLabelPositionInsideBaseYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned arbitrarily.
xlLabelPositionBestFitYou should access and use this enumeration from the Excel primary interop assembly (PIA). Office application controls position of data label.
xlLabelPositionMixedYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label positioned at bottom of bar or pie.
xlLabelPositionCustomYou should access and use this enumeration from the Excel primary interop assembly (PIA). Data label centered on data point or inside bar or pie.
Show: