XlDataLabelPosition Enumeration (Excel)

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.

Specifies where the data label is positioned.

Name

Value

Description

xlLabelPositionAbove

0

Data label is positioned above the data point.

xlLabelPositionBelow

1

Data label is positioned below the data point.

xlLabelPositionBestFit

5

Microsoft Office Excel 2007 sets the position of the data label.

xlLabelPositionCenter

-4108

Data label is centered on the data point or is inside a bar or pie chart.

xlLabelPositionCustom

7

Data label is in a custom position.

xlLabelPositionInsideBase

4

Data label is positioned inside the data point at the bottom edge.

xlLabelPositionInsideEnd

3

Data label is positioned inside the data point at the top edge.

xlLabelPositionLeft

-4131

Data label is positioned to the left of the data point.

xlLabelPositionMixed

6

Data labels are in multiple positions.

xlLabelPositionOutsideEnd

2

Data label is positioned outside the data point at the top edge.

xlLabelPositionRight

-4152

Data label is positioned to the right of the data point.

Show: