XlDataLabelPosition Enumeration (Word)

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

The data label is positioned above the data point.

xlLabelPositionBelow

1

The data label is positioned below the data point.

xlLabelPositionBestFit

5

Word sets the position of the data label.

xlLabelPositionCenter

-4108

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

xlLabelPositionCustom

7

The data label is in a custom position.

xlLabelPositionInsideBase

4

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

xlLabelPositionInsideEnd

3

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

xlLabelPositionLeft

-4131

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

xlLabelPositionMixed

6

Data labels are in multiple positions.

xlLabelPositionOutsideEnd

2

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

xlLabelPositionRight

-4152

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

Show: