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

This example specifies the chart title with the specified parameters.

// How to add chart title indicating its font size.

// Add title for a chart with its font size and style.

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.CreateRGBColor(51, 51, 51));
chart.SetSeriesFill(fill, 0, false);
fill = Api.CreateSolidFill(Api.CreateRGBColor(255, 111, 61));
chart.SetSeriesFill(fill, 1, false);