Page History

{description}
{excerpt}
The possible positions of a data label relative to its data point.
{excerpt}
{signature:C#}
public enum DataLabelPlacementType

{signature}
{signature:vb.net

}
Public Enum DataLabelPlacementType

{signature}
{remarks}
{note}If you attempt to use a DataLabelPlacementType that does not correspond with the series' ChartType, you will receive the error "Error setting Data Label Placement: The data label placement type is not valid for this type of chart".{note}
{remarks}
{example}
{code:csharp|title=C#}
//--- Create chart
Chart chart = ws.Charts.CreateChart(ChartType.Column.Stacked, ws.CreateAnchor(10, 0, 0, 0));

//--- Create data series
Series series = chart.SeriesCollection.CreateSeries("A1:A10");

//--- Set the data label position for the first SeriesDataLabel to OutsideEnd
series[0].Label.DataLabelPlacement = DataLabelPlacementType.OutsideEnd;

{code}
{code:vb.net

|title=vb.net

}
'--- Create chart
Dim chart As Chart = ws.Charts.CreateChart(ChartType.Column.Stacked, ws.CreateAnchor(10, 0, 0, 0))

'--- Create data series
Dim series As Series = chart.SeriesCollection.CreateSeries("A1:A10")

'--- Set the data label position for the first SeriesDataLabel to OutsideEnd
series(0).Label.DataLabelPlacement = DataLabelPlacementType.OutsideEnd

...

Name

...

Description

...

The default data label position for column, bar, bubble, doughnut, line, and scatter charts

...

Places the data label on the outside of the data point in pie, column, and bar charts

...

Places the data label inside the data point, near its edge in column, bar, and pie charts

...

Places the data label in the center of the data point in bubble, line, and scatter charts

...

Places the data label on the inside of the data point, near its base in column and bar charts

...

Places the data label above the data point in bubble, line, and scatter charts

...

Places the data label below the data point in bubble, line, and scatter charts

...

Places the data label to the left of the data point in bubble, line, and scatter charts

...

Places the data label to the right of the data point in bubble, line, and scatter charts

...

Automatically place the data label depending on the space available. This is only available for pie charts, for which it sets the data label placement to "Best Fit"

...

{code}

{example}
{values}
||Name||Description||
|{anchor:Default} Default | The default data label position for column, bar, bubble, doughnut, line, and scatter charts |
|{anchor:OutsideEnd} OutsideEnd | Places the data label on the outside of the data point in pie, column, and bar charts |
|{anchor:InsideEnd} InsideEnd | Places the data label inside the data point, near its edge in column, bar, and pie charts |
|{anchor:Center} Center | Places the data label in the center of the data point in bubble, line, and scatter charts |
|{anchor:InsideBase} InsideBase | Places the data label on the inside of the data point, near its base in column and bar charts |
|{anchor:Above} Above | Places the data label above the data point in bubble, line, and scatter charts |
|{anchor:Below} Below | Places the data label below the data point in bubble, line, and scatter charts |
|{anchor:Left} Left | Places the data label to the left of the data point in bubble, line, and scatter charts |
|{anchor:Right} Right | Places the data label to the right of the data point in bubble, line, and scatter charts |
|{anchor:Auto} Auto | Automatically place the data label depending on the space available. This is only available for pie charts, for which it sets the data label placement to "Best Fit" |
|{anchor:MovedByUser} MovedByUser | Place the data label at an arbitrary x and y position for any chart type |