SetDataPointOutLine

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

Syntax

expression.SetDataPointOutLine(oStroke, nSeries, nDataPoint, bAllSeries);

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 data point outline.
nSeries	Required	number		The index of the chart series.
nDataPoint	Required	number		The index of the data point in the specified chart series.
bAllSeries	Required	boolean		Specifies if the outline will be applied to the specified data point in all series.

Returns

boolean

Example

Add a visible border around a single data point on a chart in a spreadsheet.

// How do I draw an outline on one specific data point in a chart series in a spreadsheet?

// Distinguish an individual bar or marker by giving it a colored border 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);
let stroke = Api.CreateStroke(0.5 * 36000, Api.CreateSolidFill(Api.RGB(51, 51, 51)));
chart.SetDataPointOutLine(stroke, 1, 0, false);