Message-ID: <2060699645.8287.1711639923556.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8286_661476531.1711639923556" ------=_Part_8286_661476531.1711639923556 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html DataLabelPlacementType

DataLabelPlacementType

Description

=20

The possible positions of a data label relative to its data point.

=20
C#
=20
public enum DataLabelPlacementType
=20
=20
vb.net
=20
Public Enum DataLabelPlacementType
=20
=20

Remarks

=20
=20 Icon=20
=20

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 t= ype of chart".

=20
=20
=20

Examples

=20
C#
=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
=20
vb.net
=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
=20

Values

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Default

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

OutsideEnd

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

InsideEnd

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

Center

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

InsideBase

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

Above

Places the data label above the data point i= n bubble, line, and scatter charts

Below

Places the data label below the data point i= n bubble, line, and scatter charts

Left

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

Right

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

Auto

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"

MovedByUser

Place the data label at an arbitrary x and y= position for any chart type

------=_Part_8286_661476531.1711639923556--