SetHorAxisOrientation
Specify 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