Table of contents
TOC
Collapse the table of content
Expand the table of content

XlDataLabelPosition Enumeration (Office)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Indicates the position of data labels relative to the data markers.

NameValueDescription
xlLabelPositionAbove0Data label positioned above point.
xlLabelPositionBelow1Data label positioned below point.
xlLabelPositionBestFit5Office application controls position of data label.
xlLabelPositionCenter-4108Data label centered on data point or inside bar or pie.
xlLabelPositionCustom7Data label centered on data point or inside bar or pie.
xlLabelPositionInsideBase4Data label positioned arbitrarily.
xlLabelPositionInsideEnd3Data label positioned arbitrarily.
xlLabelPositionLeft-4131Data label positioned at bottom of bar or pie.
xlLabelPositionMixed6Data label positioned at bottom of bar or pie.
xlLabelPositionOutsideEnd2Data label positioned at top of bar or pie.
xlLabelPositionRight-4152Data label positioned at top of bar or pie.
© 2018 Microsoft