ig.excel.DataLabelPosition
Remarks
Note that which constants in this enumeration are applicable is dependent on the chart type.
The following table lists the supported constants for each chart type.
| Chart Type | Supported Constant(s) |
|---|---|
| 3D charts (except pie/doughnut) | Custom |
| Area, Radar | Custom |
| Surface | Data labels are not supported |
| Bar/Column (stacked) | Center, InsideEnd, InsideBase |
| Bar/Column (clustered) | Center, InsideEnd, InsideBase, OutsideEnd |
| Line/Scatter/Bubble | Center, Left, Right, Above, Below |
| Pie/Doughnut | Center, InsideEnd, OutsideEnd, BestFit |
Dependencies
-
above
- Type:
- ig.excel.DataLabelPosition
- Default:
- 8
The label is positioned above the associated data point.
-
below
- Type:
- ig.excel.DataLabelPosition
- Default:
- 9
The label is positioned below the associated data point.
-
bestFit
- Type:
- ig.excel.DataLabelPosition
- Default:
- 10
The label is positioned where it best fits with relation to the associated pie slice.
-
center
- Type:
- ig.excel.DataLabelPosition
- Default:
- 1
The label is centered with respect to the associated data point.
-
custom
- Type:
- ig.excel.DataLabelPosition
- Default:
- 5
The label's position is explicitly defined via the ChartTextAreaBase.left and ChartTextAreaBase.top properties.
-
default
- Type:
- ig.excel.DataLabelPosition
- Default:
- 0
The label position is not specified, and is determined automatically by Excel.
-
insideBase
- Type:
- ig.excel.DataLabelPosition
- Default:
- 2
The label's left edge coincides with the left edge of the series bar/line.
-
insideEnd
- Type:
- ig.excel.DataLabelPosition
- Default:
- 3
The label's right edge coincides with the right edge of the series bar/line.
-
left
- Type:
- ig.excel.DataLabelPosition
- Default:
- 6
The label is positioned to the left of the associated data point.
-
outsideEnd
- Type:
- ig.excel.DataLabelPosition
- Default:
- 4
The label's left edge coincides with the right edge of the series bar/line.
-
right
- Type:
- ig.excel.DataLabelPosition
- Default:
- 7
The label is positioned to the right of the associated data point.