Edit

Share via


XlDataLabelPosition Enum

Definition

Specifies where the data label is positioned.

public enum class XlDataLabelPosition
public enum XlDataLabelPosition
Public 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.

Applies to