Get Started
Usage API
More information

SetHorAxisTickLabelPosition

SetHorAxisTickLabelPosition(sTickLabelPosition)

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

Parameters:

Name Type Description
sTickLabelPosition TickLabelPosition

The type for the position of chart horizontal tick labels.

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
var 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);
var oChart = oWorksheet.AddChart("'Sheet1'!$A$1:$D$3", true, "bar3D", 2, 100 * 36000, 70 * 36000, 0, 2 * 36000, 5, 3 * 36000);
oChart.SetTitle("Financial Overview", 13);
oChart.SetHorAxisTickLabelPosition("high");
builder.SaveFile("xlsx", "SetHorAxisTickLabelPosition.xlsx");
builder.CloseFile();

Resulting document