SetTitle

Specifies the chart title.

Syntax

expression.SetTitle(sTitle, nFontSize, bIsBold);

expression - A variable that represents a ApiChart class.

Parameters

Name	Required/Optional	Data type	Default	Description
sTitle	Required	string		The title which will be displayed for the current chart.
nFontSize	Required	pt		The text size value measured in points.
bIsBold	Required	boolean		Specifies if the chart title is written in bold font or not.

Returns

boolean

Example

Add a title to a chart with a chosen font size in a spreadsheet.

// How do I set the heading text and font size for a chart in a spreadsheet?

// Label a chart clearly by giving it a descriptive title at a readable font size 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, 5, 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);