Excel charts are used to visualize the data in spreadsheets. MS Excel supports a variety of charts such as line, bar, pie, doughnut, pyramid, bubble, etc. In this article, you will learn how to create charts in Excel files using C#.
- C# API to Create Charts in Excel
- Create Charts in Excel using C#
- Create a Line Chart in Excel using C#
- Generate a Pyramid Chart in Excel using C#
- Get a Free API License
C# API to Create Charts in Excel
In order to work with Excel charts, we’ll use Aspose.Cells for .NET. It is a powerful API that lets you implement Excel automation in .NET applications. Furthermore, it allows you create a variety of charts seamlessly. To use the API, you can either download the DLL or install it using NuGet.
Install-Package Aspose.Cells
Supported Excel Chart Types
Aspose.Cells for .NET provides a complete set of standard chart types. The list includes, but not limited to:
- Column
- ColumnStacked
- Column100PercentStacked
- Column3DClustered
- Column3DStacked
- Column3D100PercentStacked
- Column3D
- Bar
- BarStacked
- Bar100PercentStacked
- Bar3DClustered
- Bar3DStacked
- Bar3D100PercentStacked
- Line
- LineStacked
- Line100PercentStacked
- LineWithDataMarkers
- LineStackedWithDataMarkers
- Line100PercentStackedWithDataMarkers
- Line3D
- Pie
- Pie3D
- PiePie
- PieExploded
- Pie3DExploded
- PieBar
- Scatter
- ScatterConnectedByCurvesWithDataMarker
For a complete list of supported Excel charts, visit this article.
Create Charts in Excel using C#
The following are the steps to create a chart in Excel using C#.
- First, create a new Excel workbook or load an existing one using Workbook class.
- Access the desired worksheet into a Worksheet object.
- Insert data into the worksheet (if worksheet is empty).
- Create a chart in the worksheet using Worksheet.Charts.Add(ChartType type, int upperLeftRow, int upperLeftColumn, int lowerRightRow, int lowerRightColumn) method.
- Access the chart by its index into a Chart object.
- Set data source for the chart using Chart.SetChartDataRange(“A1:C4”, true) method.
- Finally, save the workbook using Workbook.Save(string) method.
The following code sample shows how to create an Excel chart using C#.
Create a Line Chart in Excel using C#
In order to insert a line chart, you only need to specify the ChartType.Line type in Worksheet.Charts.Add() method. The rest of the steps will be the same as mentioned in the previous section.
- First, create an Excel workbook using the Workbook class.
- Access the desired worksheet into a Worksheet object.
- Insert data into the worksheet.
- Create the line chart using Worksheet.Charts.Add() method.
- Access the chart by its index into a Chart object.
- Set data source for the chart using Chart.SetChartDataRange(“A1:C4”, true) method.
- Finally, ave the workbook using Workbook.Save(string) method.
The following code sample shows how to create a line chart in Excel using C#.
Create a Pyramid Chart in Excel using C#
For adding a pyramid chart, simply pass ChartType.Pyramid type while adding the chart to the worksheet. The following are the steps to add a pyramid chart in Excel using C#.
- First, create an Excel workbook using the Workbook class.
- Access the desired worksheet into a Worksheet object.
- Insert data into the worksheet.
- Create the pyramid chart using Worksheet.Charts.Add() method.
- Access the chart by its index into a Chart object.
- Set data source for the chart using Chart.SetChartDataRange(“A1:C4”, true) method.
- Finally, save the workbook using Workbook.Save(string) method.
The following code sample shows how to insert a pyramid chart in an Excel worksheet using C#.
To learn more about working with Excel charts, read this documentation article.
Get a Free API License
You can try Aspose.Cells for .NET without evaluation limitations by requesting a temporary license.
Conclusion
In this article, you have seen how to create charts in Excel worksheets using C#. Particularly, you have learned how to create column, line, and pyramid charts in Excel. Furthermore, you can also create other types of charts seamlessly using Aspose.Cells for .NET. For more details, visit the documentation of the API. In case you would have any queries, contact us via our forum.