Wiki Markup |
---|
{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 {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 | |
Page History
Overview
Content Tools