Get Started
Usage API
More information

ApiChart

new ApiChart()

Class representing a chart.

Methods

Name Description
ApplyChartStyle

Applies a set of visual settings to the chart.

GetClassType

Returns a type of the ApiChart class.

SetHorAxisLablesFontSize

Specifies the font size to the horizontal axis labels.

SetHorAxisMajorTickMark

Specifies the major tick mark for the horizontal axis.

SetHorAxisMinorTickMark

Specifies the minor tick mark for the horizontal axis.

SetHorAxisOrientation

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

SetHorAxisTickLabelPosition

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

SetHorAxisTitle

Specifies the chart horizontal axis title.

SetLegendFontSize

Specifies the legend font size.

SetLegendPos

Specifies the chart legend position.

SetMajorHorizontalGridlines

Specifies the visual properties of the major horizontal gridline.

SetMajorVerticalGridlines

Specifies the visual properties of the major vertical gridline.

SetMinorHorizontalGridlines

Specifies the visual properties of the minor vertical gridline.

SetMinorVerticalGridlines

Specifies the visual properties of the minor vertical gridline.

SetShowDataLabels

Specifies which chart data labels are shown for the chart.

SetShowPointDataLabel

Spicifies the show options for the data labels.

SetTitle

Specifies the chart title with the specified parameters.

SetVerAxisOrientation

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

SetVerAxisTitle

Specifies the chart vertical axis title.

SetVertAxisLablesFontSize

Specifies the font size to the vertical axis labels.

SetVertAxisMajorTickMark

Specifies the major tick mark for the vertical axis.

SetVertAxisMinorTickMark

Specifies the minor tick mark for the vertical axis.

SetVertAxisTickLabelPosition

Sets 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");
var 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");
var oChart = oWorksheet.AddChart("'sheet 1'!$A$1:$D$5", true, "bar", 2, 100 * 36000, 70 * 36000, 0, 2 * 36000, 5, 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