SetShowDataLabels

Specifies which chart data labels are shown for the chart.

Syntax

expression.SetShowDataLabels(bShowSerName, bShowCatName, bShowVal, bShowPercent);

expression - A variable that represents a ApiChart class.

Parameters

Name	Required/Optional	Data type	Default	Description
bShowSerName	Required	boolean		Whether to show or hide the source table column names used for the data which the chart will be build from.
bShowCatName	Required	boolean		Whether to show or hide the source table row names used for the data which the chart will be build from.
bShowVal	Required	boolean		Whether to show or hide the chart data values.
bShowPercent	Required	boolean		Whether to show or hide the percent for the data values (works with stacked chart types).

Returns

boolean

Example

Control which data label elements are displayed on a chart in a spreadsheet.

// How do I choose what information appears in chart data labels in a spreadsheet?

// Show only the numeric values on chart bars while hiding category names and percentages in a spreadsheet.

let worksheet = Api.GetActiveSheet();
worksheet.GetRange("B1").SetValue(2014);
worksheet.GetRange("C1").SetValue(2015);
worksheet.GetRange("D1").SetValue(2016);
worksheet.GetRange("A2").SetValue("Projected Revenue");
worksheet.GetRange("A3").SetValue("Estimated Costs");
worksheet.GetRange("B2").SetValue(200);
worksheet.GetRange("B3").SetValue(250);
worksheet.GetRange("C2").SetValue(240);
worksheet.GetRange("C3").SetValue(260);
worksheet.GetRange("D2").SetValue(280);
worksheet.GetRange("D3").SetValue(280);
let chart = worksheet.AddChart("'Sheet1'!$A$1:$D$3", true, "bar3D", 2, 100 * 36000, 70 * 36000, 0, 2 * 36000, 5, 3 * 36000);
chart.SetTitle("Financial Overview", 13);
chart.SetShowDataLabels(false, false, true, false);
let fill = Api.CreateSolidFill(Api.RGB(51, 51, 51));
chart.SetSeriesFill(fill, 0, false);
fill = Api.CreateSolidFill(Api.RGB(255, 111, 61));
chart.SetSeriesFill(fill, 1, false);