Message-ID: <638783947.10027.1711709670827.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10026_728472842.1711709670827" ------=_Part_10026_728472842.1711709670827 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The possible positions of a data label relative to its data point.
=20public enum DataLabelPlacementType=20
Public Enum DataLabelPlacementType=20
//--- Create chart Chart chart =3D ws.Charts.CreateChart(ChartType.Column.Stacked, ws.CreateAn= chor(10, 0, 0, 0)); //--- Create data series Series series =3D chart.SeriesCollection.CreateSeries("A1:A10"); //--- Set the data label position for the first SeriesDataLabel to OutsideE= nd series[0].Label.DataLabelPlacement =3D DataLabelPlacementType.OutsideEnd;=20
'--- Create chart Dim chart As Chart =3D ws.Charts.CreateChart(ChartType.Column.Stacked, ws.C= reateAnchor(10, 0, 0, 0)) '--- Create data series Dim series As Series =3D chart.SeriesCollection.CreateSeries("A1:A10&q= uot;) '--- Set the data label position for the first SeriesDataLabel to OutsideEn= d series(0).Label.DataLabelPlacement =3D DataLabelPlacementType.OutsideEnd=20
Name | =20
Description | =20
---|---|
Default | =20
The default data label position for column, = bar, bubble, doughnut, line, and scatter charts | =20
OutsideEnd | =20
Places the data label on the outside of the = data point in pie, column, and bar charts | =20
InsideEnd | =20
Places the data label inside the data point,= near its edge in column, bar, and pie charts | =20
Center | =20
Places the data label in the center of the d= ata point in bubble, line, and scatter charts | =20
InsideBase | =20
Places the data label on the inside of the d= ata point, near its base in column and bar charts | =20
Above | =20
Places the data label above the data point i= n bubble, line, and scatter charts | =20
Below | =20
Places the data label below the data point i= n bubble, line, and scatter charts | =20
Left | =20
Places the data label to the left of the dat= a point in bubble, line, and scatter charts | =20
Right | =20
Places the data label to the right of the da= ta point in bubble, line, and scatter charts | =20
Auto | =20
Automatically place the data label depending= on the space available. This is only available for pie charts, for which i= t sets the data label placement to "Best Fit" | =20
MovedByUser | =20
Place the data label at an arbitrary x and y= position for any chart type | =20