SetSeriesFill

Sets the fill to the specified chart series.

note

The fill is not applied to 2D line and scatter series. Use the SetSeriesOutLine method to change their line and the SetMarkerFill method to change their markers.

Syntax

expression.SetSeriesFill(oFill, nSeries, bAll);

expression - A variable that represents an ApiChart class.

Parameters

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

Returns

boolean

Example

Apply a solid fill color to a chart data series in a spreadsheet.

// How do I change the background color of a specific chart series in a spreadsheet?

// Distinguish chart series visually by painting each one a different 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, "3DColumnClustered", 2, 100 * 36000, 70 * 36000, 0, 2 * 36000, 7, 3 * 36000);
chart.SetTitle("Financial Overview", 26);
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);