SetMarkerFill

Sets the fill to the marker in the specified chart series.

Syntax

expression.SetMarkerFill(oFill, nSeries, nMarker, bAllMarkers);

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 marker.
nSeries	Required	number		The index of the chart series.
nMarker	Required	number		The index of the marker in the specified chart series.
bAllMarkers	Optional	boolean	false	Specifies if the fill will be applied to all markers in the specified chart series.

Returns

boolean

Example

Set the fill to the marker in the specified chart series in a spreadsheet.

// Create the "scatter" chart and apply an RGB color to its markers in a spreadsheet.

// Apply an RGB fill to the chart markers using a fill object.

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, "scatter", 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.SetMarkerFill(fill, 0, 0, true);
let stroke = Api.CreateStroke(0.5 * 36000, Api.CreateSolidFill(Api.RGB(51, 51, 51)));
chart.SetMarkerOutLine(stroke, 0, 0, true);
fill = Api.CreateSolidFill(Api.RGB(255, 111, 61));
chart.SetMarkerFill(fill, 1, 0, true);
stroke = Api.CreateStroke(0.5 * 36000, Api.CreateSolidFill(Api.RGB(255, 111, 61)));
chart.SetMarkerOutLine(stroke, 1, 0, true);