Share via


XlDataLabelPosition Enumeration

Excel Developer Reference

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.