SetDataPointFill

Sets the fill to the data point in the specified chart series.

Syntax

expression.SetDataPointFill(oFill, nSeries, nDataPoint, bAllSeries);

expression - A variable that represents a ApiChart class.

Parameters

Name	Required/Optional	Data type	Default	Description
oFill	Required	ApiFill		The fill type used to fill the data point.
nSeries	Required	number		The index of the chart series.
nDataPoint	Required	number		The index of the data point in the specified chart series.
bAllSeries	Optional	boolean	false	Specifies if the fill will be applied to the specified data point in all series.

Returns

boolean

Example

Color a single data point differently from the rest of its series in a spreadsheet.

// How do I change the background color of one specific data point on a chart in a spreadsheet?

// Highlight an individual bar or marker by giving it a distinct fill color 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, 7, 3 * 36000);
chart.SetTitle("Financial Overview", 13);
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);
fill = Api.CreateSolidFill(Api.RGB(128, 128, 128));
chart.SetDataPointFill(fill, 0, 0, false);