Get Started
Usage API
More information

SetShowPointDataLabel

SetShowPointDataLabel(nSeriesIndex, nPointIndex, bShowSerName, bShowCatName, bShowVal, bShowPercent)

Spicify the show options for data labels.

Parameters:

Name Type Description
nSeriesIndex number

The series index from the array of the data used to build the chart from.

nPointIndex number

The point index from this series.

bShowSerName bool

Whether to show or hide the source table column names used for the data which the chart will be build from.

bShowCatName bool

Whether to show or hide the source table row names used for the data which the chart will be build from.

bShowVal bool

Whether to show or hide the chart data values.

bShowPercent bool

Whether to show or hide the percent for the data values (works with stacked chart types).

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("B1").SetValue(2014);
oWorksheet.GetRange("C1").SetValue(2015);
oWorksheet.GetRange("D1").SetValue(2016);
oWorksheet.GetRange("A2").SetValue("Projected Revenue");
oWorksheet.GetRange("A3").SetValue("Estimated Costs");
oWorksheet.GetRange("B2").SetValue(200);
oWorksheet.GetRange("B3").SetValue(250);
oWorksheet.GetRange("C2").SetValue(240);
oWorksheet.GetRange("C3").SetValue(260);
oWorksheet.GetRange("D2").SetValue(280);
oWorksheet.GetRange("D3").SetValue(280);
oChart = oWorksheet.AddChart("'Sheet1'!$A$1:$D$3", true, "bar3D", 2, 100 * 36000, 70 * 36000, 5, 2 * 36000, 1, 3 * 36000);
oChart.SetTitle("Financial Overview", 13);
oChart.SetShowPointDataLabel(1, 0, false, false, true, false);
builder.SaveFile("xlsx", "SetShowPointDataLabel.xlsx");
builder.CloseFile();

Resulting document