Get Started
Usage API
More information

SetHorAxisOrientation

SetHorAxisOrientation(bIsMinMax)

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

Parameters:

Name Type Description
bIsMinMax boolean

The true value sets the normal data direction for the horizontal axis (from minimum to maximum). The false value sets 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");
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.SetHorAxisOrientation(false);
builder.SaveFile("xlsx", "SetHorAxisOrientation.xlsx");
builder.CloseFile();

Resulting document