SetMarkerOutLine

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

Syntax

expression.SetMarkerOutLine(oStroke, nSeries, nMarker, bAllMarkers);

expression - A variable that represents a ApiChart class.

Parameters

Name	Required/Optional	Data type	Default	Description
oStroke	Required	ApiStroke		The stroke used to create the marker outline.
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 outline will be applied to all markers in the specified chart series.

Returns

boolean

Example

Add a colored border to the data point markers in a chart series in a spreadsheet.

// How do I outline the markers of a scatter chart with a specific color and width in a spreadsheet?

// Give each series marker a distinct border to make individual data points easier to identify 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, "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);
chart.SetMarkerOutLine(stroke, 1, 0, true);