Export (0) Print
Expand All
Expand Minimize

XlDataLabelPosition Enumeration

Office 2007
Specifies where the data label is positioned.
NameValueDescription
xlLabelPositionAbove0Data label is positioned above the data point.
xlLabelPositionBelow1Data label is positioned below the data point.
xlLabelPositionBestFit5Microsoft Office Excel 2007 sets the position of the data label.
xlLabelPositionCenter-4108Data label is centered on the data point or is inside a bar or pie chart.
xlLabelPositionCustom7Data label is in a custom position.
xlLabelPositionInsideBase4Data label is positioned inside the data point at the bottom edge.
xlLabelPositionInsideEnd3Data label is positioned inside the data point at the top edge.
xlLabelPositionLeft-4131Data label is positioned to the left of the data point.
xlLabelPositionMixed6Data labels are in multiple positions.
xlLabelPositionOutsideEnd2Data label is positioned outside the data point at the top edge.
xlLabelPositionRight-4152Data label is positioned to the right of the data point.


Community Additions

ADD
Show:
© 2014 Microsoft