Skip to main content

SetHorAxisTitle

Specifies the chart horizontal axis title.

Syntax

expression.SetHorAxisTitle(sTitle, nFontSize, bIsBold);

expression - A variable that represents a ApiChart class.

Parameters

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

Returns

boolean

Example

Specify the chart horizontal axis title in a spreadsheet.

// How to set title for horizontal axis in a spreadsheet.

// Add title for the axis using the chart API 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.SetHorAxisTitle("Year", 11);
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);