Get Started
Usage API

SetHorAxisTickLabelPosition

SetHorAxisTickLabelPosition(sTickLabelPosition)

Set the possible values for the position of the chart tick labels in relation to the main horizontal label or the values of the chart data.

Parameters:

Name Type Description
sTickLabelPosition TickLabelPosition

Set the position of the chart horizontal tick labels.

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.SetHorAxisTickLabelPosition("high");
builder.SaveFile("xlsx", "SetHorAxisTickLabelPosition.xlsx");
builder.CloseFile();

Resulting document