Expand Minimize

XlDataLabelPosition Enumeration (Office)

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