跳到主要内容

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

This method doesn't return any data.

Example

This example specifies the chart title with the specified parameters.

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);