Export (0) Print
Expand All
Expand Minimize

XlDataLabelPosition Enumeration

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:
© 2015 Microsoft