SetVerAxisTitle

Specifies the chart vertical axis title.

Syntax

expression.SetVerAxisTitle(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 vertical axis of the current chart.
nFontSize	Required	pt		The text size value measured in points.
bIsBold	Required	boolean		Specifies if the vertical axis title is written in bold font or not.

Returns

boolean

Example

Add a descriptive label to the vertical axis of a chart in a spreadsheet.

// How do I give the vertical axis of a chart its own title in a spreadsheet?

// Label the vertical axis so readers know what the values represent 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);
chart.SetVerAxisTitle("USD In Hundred Thousands", 10);
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);