XlDataLabelPosition Enumeration (Office)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Indicates the position of data labels relative to the data markers.

Name

Value

Description

xlLabelPositionAbove

0

Data label positioned above point.

xlLabelPositionBelow

1

Data label positioned below point.

xlLabelPositionBestFit

5

Office application controls position of data label.

xlLabelPositionCenter

-4108

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

xlLabelPositionCustom

7

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

xlLabelPositionInsideBase

4

Data label positioned arbitrarily.

xlLabelPositionInsideEnd

3

Data label positioned arbitrarily.

xlLabelPositionLeft

-4131

Data label positioned at bottom of bar or pie.

xlLabelPositionMixed

6

Data label positioned at bottom of bar or pie.

xlLabelPositionOutsideEnd

2

Data label positioned at top of bar or pie.

xlLabelPositionRight

-4152

Data label positioned at top of bar or pie.

Show: