Get Started
Usage API
More information

SetVerAxisTitle

SetVerAxisTitle(sTitle, nFontSize, bIsBold)

Specify the chart vertical axis title.

Parameters:

Name Type Description
sTitle string

The title which will be displayed for the vertical axis of the current chart.

nFontSize pt

The text size value measured in points.

bIsBold bool

Specifies if the vertical axis title is written in bold font or not.

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("B1").SetValue(2014);
oWorksheet.GetRange("C1").SetValue(2015);
oWorksheet.GetRange("D1").SetValue(2016);
oWorksheet.GetRange("A2").SetValue("Projected Revenue");
oWorksheet.GetRange("A3").SetValue("Estimated Costs");
oWorksheet.GetRange("B2").SetValue(200);
oWorksheet.GetRange("B3").SetValue(250);
oWorksheet.GetRange("C2").SetValue(240);
oWorksheet.GetRange("C3").SetValue(260);
oWorksheet.GetRange("D2").SetValue(280);
oWorksheet.GetRange("D3").SetValue(280);
oChart = oWorksheet.AddChart("'Sheet1'!$A$1:$D$3", true, "bar3D", 2, 100 * 36000, 70 * 36000, 5, 2 * 36000, 1, 3 * 36000);
oChart.SetTitle("Financial Overview", 13);
oChart.SetVerAxisTitle("USD In Hundred Thousands", 10);
builder.SaveFile("xlsx", "SetVerAxisTitle.xlsx");
builder.CloseFile();

Resulting document