Skip to main content

SetTitle

Specifies the chart title.

Syntax

expression.SetTitle(sTitle, nFontSize, bIsBold);

expression - A variable that represents a ApiChart class.

Parameters

NameRequired/OptionalData typeDefaultDescription
sTitleRequiredstringThe title which will be displayed for the current chart.
nFontSizeRequiredptThe text size value measured in points.
bIsBoldRequiredbooleanSpecifies if the chart title is written in bold font or not.

Returns

boolean

Example

Specify the chart title with the specified parameters in a spreadsheet.

// How to add chart title indicating its font size in a spreadsheet.

// Add title for a chart with its font size and style 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);