'Declaration Public Enum DataLabelPosition Inherits System.Enum
public enum DataLabelPosition : System.Enum
Member | Description |
---|---|
Above | The label is positioned above the associated data point. |
Below | The label is positioned below the associated data point. |
BestFit | The label is positioned where it best fits with relation to the associated pie slice. |
Center | The label is centered with respect to the associated data point. |
Custom | The label's position is explicitly defined via the ChartTextAreaBase.Left and ChartTextAreaBase.Top properties. |
Default | The label position is not specified, and is determined automatically by Excel. |
InsideBase | The label's left edge coincides with the left edge of the series bar/line. |
InsideEnd | The label's right edge coincides with the right edge of the series bar/line. |
Left | The label is positioned to the left of the associated data point. |
OutsideEnd | The label's left edge coincides with the right edge of the series bar/line. |
Right | The label is positioned to the right of the associated data point. |
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 |
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2