XlDataLabelPosition XlDataLabelPosition XlDataLabelPosition Enum

Definition

Specifies where the data label is positioned.

public enum class XlDataLabelPosition
public enum XlDataLabelPosition
Public Enum XlDataLabelPosition
Inheritance
XlDataLabelPositionXlDataLabelPositionXlDataLabelPosition

Fields

xlLabelPositionAbove xlLabelPositionAbove xlLabelPositionAbove 0

Data label above point.

xlLabelPositionBelow xlLabelPositionBelow xlLabelPositionBelow 1

Data label below point.

xlLabelPositionBestFit xlLabelPositionBestFit xlLabelPositionBestFit 5

Excel controls position of data label.

xlLabelPositionCenter xlLabelPositionCenter xlLabelPositionCenter -4108

Data label centered on data point or inside bar or pie.

xlLabelPositionCustom xlLabelPositionCustom xlLabelPositionCustom 7

Data label centered on data point or inside bar or pie.

xlLabelPositionInsideBase xlLabelPositionInsideBase xlLabelPositionInsideBase 4

Data label positioned arbitrarily.

xlLabelPositionInsideEnd xlLabelPositionInsideEnd xlLabelPositionInsideEnd 3

Data label positioned arbitrarily.

xlLabelPositionLeft xlLabelPositionLeft xlLabelPositionLeft -4131

Data label positioned at bottom of bar or pie.

xlLabelPositionMixed xlLabelPositionMixed xlLabelPositionMixed 6

Data label positioned at bottom of bar or pie.

xlLabelPositionOutsideEnd xlLabelPositionOutsideEnd xlLabelPositionOutsideEnd 2

Data label positioned at top of bar or pie.

xlLabelPositionRight xlLabelPositionRight xlLabelPositionRight -4152

Data label positioned at top of bar or pie.

Applies to