Create Bubble Charts via C#
Native and high performance MS Excel Charts creation programmatically using server side .NET APIs.
How to Create Bubble Charts via C#
It is easy for the developers to create a Bubble chart within running different reporting applications for data processing in just a few lines of code.
- Include the namespace in your class file
- Create Workbook class instance.
- Add some data to worksheet cells with the Cell object’s PutValue method. This will be used as the data source for the chart.
- Add a Bubble Chart to the worksheet by calling the Charts collection’s Add method, encapsulated in the Worksheet object.
- Access the new Chart object from the Charts collection by passing its index.
- Use Chart.SetChartDataRange method to specify the chart’s data source.
System Requirements
Just make sure that system have Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Windows Azure, Mono or Xamarin Platforms as well as development environment like Microsoft Visual Studio.
- Install from command line asnuget install Aspose.Cells
or via Package Manager Console of Visual Studio with Install-Package Aspose.Cells
.
- Alternatively, get the offline MSI installer or all DLLs in a ZIP file from downloadsFollowing source code shows how to create a Bubble Chart to MS Excel XLSX file using C#.
// Instantiating a Workbook object | |
Workbook wkb = new Workbook(); | |
// Obtaining the reference of the first worksheet | |
Worksheet wks = wkb.Worksheets[0]; | |
// Adding sample values to cells | |
wks.Cells["A2"].PutValue("Category1"); | |
wks.Cells["A3"].PutValue("Category2"); | |
wks.Cells["A4"].PutValue("Category3"); | |
wks.Cells["B1"].PutValue("Bubble"); | |
wks.Cells["B2"].PutValue(324); | |
wks.Cells["B3"].PutValue(200); | |
wks.Cells["B4"].PutValue(450); | |
// Adding a Bubble chart to the worksheet | |
int chartIndex = wks.Charts.Add(Aspose.Cells.Charts.ChartType.Bubble, 6, 2, 20, 5); | |
// Accessing the instance of the newly added chart | |
Aspose.Cells.Charts.Chart chart = wks.Charts[chartIndex]; | |
// Setting chart data source as the range "A1:C4" | |
chart.SetChartDataRange("A1:B4", true); | |
// Save the Workbook as .xlsx file. | |
wkb.Save("output.xlsx"); |