Get Started
Documentation

SetHorAxisOrientation

SetHorAxisOrientation(bIsMinMax)

Specifies the direction of the data displayed on the horizontal axis.

Parameters:

Name Type Description
bIsMinMax bool

The true value will set the normal data direction for the horizontal axis (from minimum to maximum). The false value will set the inverted data direction for the horizontal axis (from maximum to minimum).

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

Resulting document