Get Started
Usage API
More information

ApiChart

new ApiChart()

Class representing a chart.

Methods

Name Description
ApplyChartStyle

Apply set of visual settings to the chart.

GetClassType

Get the type of this class.

SetHorAxisLablesFontSize

Specify font size for the horizontal axis labels.

SetHorAxisMajorTickMark

Specify major tick mark for horizontal axis.

SetHorAxisMinorTickMark

Specify minor tick mark for horizontal axis.

SetHorAxisOrientation

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

SetHorAxisTickLabelPosition

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

SetHorAxisTitle

Specify the chart horizontal axis title.

SetLegendFontSize

Specify the legend font size.

SetLegendPos

Specify the chart legend position.

SetMajorHorizontalGridlines

Specify major horizontal gridline's visual properties.

SetMajorVerticalGridlines

Specify major vertical gridline's visual properties.

SetMinorHorizontalGridlines

Specify minor vertical gridline's visual properties.

SetMinorVerticalGridlines

Specify minor vertical gridline's visual properties.

SetShowDataLabels

Specify which chart data labels are shown for the chart.

SetShowPointDataLabel

Spicify the show options for data labels.

SetTitle

Specify the chart title.

SetVerAxisOrientation

Specify the direction of the data displayed on the vertical axis.

SetVerAxisTitle

Specify the chart vertical axis title.

SetVertAxisLablesFontSize

Specify font size for the vertical axis labels.

SetVertAxisMajorTickMark

Specify major tick mark for vertical axis.

SetVertAxisMinorTickMark

Specify minor tick mark for vertical axis.

SetVertAxisTickLabelPosition

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

Example

Copy code
builder.CreateFile("xlsx");
oWorksheet = Api.GetActiveSheet();
oWorksheet.SetName("sheet 1");
oWorksheet.GetRange("B1").SetValue("Row 1");
oWorksheet.GetRange("C1").SetValue("Row 2");
oWorksheet.GetRange("D1").SetValue("Row 3");
oWorksheet.GetRange("A2").SetValue("Category 1");
oWorksheet.GetRange("A3").SetValue("Category 2");
oWorksheet.GetRange("A4").SetValue("Category 3");
oWorksheet.GetRange("A5").SetValue("Category 4");
oWorksheet.GetRange("B2").SetValue("4.3");
oWorksheet.GetRange("B3").SetValue("2.5");
oWorksheet.GetRange("B4").SetValue("3.5");
oWorksheet.GetRange("B5").SetValue("4.5");
oWorksheet.GetRange("C2").SetValue("2.4");
oWorksheet.GetRange("C3").SetValue("4.4");
oWorksheet.GetRange("C4").SetValue("1.8");
oWorksheet.GetRange("C5").SetValue("2.8");
oWorksheet.GetRange("D2").SetValue("2");
oWorksheet.GetRange("D3").SetValue("2");
oWorksheet.GetRange("D4").SetValue("3");
oWorksheet.GetRange("D5").SetValue("5");
oChart = oWorksheet.AddChart("'sheet 1'!$A$1:$D$5", true, "bar", 2, 100 * 36000, 70 * 36000, 5, 2 * 36000, 1, 3 * 36000);
oChart.SetVerAxisTitle("Vertical Title", 10);
oChart.SetHorAxisTitle("Horizontal Title", 11);
oChart.SetLegendPos("right");
oChart.SetShowDataLabels(false, false, true, false);
oChart.SetTitle("Main Chart Title", 13);
builder.SaveFile("xlsx", "ApiChart.xlsx");
builder.CloseFile();

Resulting document