Visualizing proportional data is often best done with a pie chart. When you need to highlight a particular slice, an exploded pie chart—known in Aspose.Cells as PieExploded—does the job perfectly. This guide walks you through creating a PieExploded chart in Excel using C# with Aspose.Cells for .NET. The example is complete, fully commented, and ready to compile.
This article covers the following topics:
- C# Excel Library to Create PieExploded Charts
- Create a PieExploded Chart in Excel using C#
- Get a Free License
- Free Resources
- Conclusion
- See Also
C# Excel Library to Create PieExploded Charts
Aspose.Cells for .NET is a comprehensive Excel API that enables developers to create, modify, and render Excel files without Microsoft Office. Among its many chart types, ChartType.PieExploded produces a pie chart where the first data point is “exploded” (offset from the centre), drawing immediate attention to that slice.
Key advantages of using Aspose.Cells for chart automation:
- Rich Chart Portfolio – Over 50 chart types, including all pie variations.
- Full .NET Compatibility – Works with .NET Framework, .NET Core, and .NET 6/7.
- No COM/Interop – Pure managed code, ideal for server‑side environments.
- High Fidelity Rendering – Charts look identical to native Excel.
Getting started is simple:
Download the latest release from the Aspose.Cells releases page.
Add the NuGet package to your project:
PM> Install-Package Aspose.Cells
Create a PieExploded Chart in Excel using C#
Below is a complete, ready‑to‑run C# console program that:
- Creates a new workbook.
- Populates it with sample sales data.
- Adds a PieExploded chart.
- Customizes the chart title, legend, and the exploded slice distance.
- Saves the workbook to disk.
Explanation of Key Steps
| Step | Purpose |
|---|---|
| Create workbook & worksheet | Provides a container for the data and chart. |
| Populate data | Supplies the numeric values (Revenue) and categories (Product). |
| Add chart | ChartType.PieExploded creates a pie chart with the first slice offset. |
| Set series & category data | Links the chart to the worksheet ranges. |
| Explosion property | Controls how far the first slice is displaced (percentage of the radius). |
| Legend & data labels | Improves readability and highlights the exploded slice. |
| Save | Writes the Excel file to disk. |
Run the program, open the generated PieExplodedChart_Output.xlsx, and you’ll see a visually appealing exploded pie chart that instantly draws attention to the Laptop slice.
Get a Free License
Curious about the full capabilities of Aspose.Cells? Visit the temporary license page and obtain a free, time‑limited license. It removes evaluation watermarks and lets you explore the library without restrictions.
Free Resources
Boost your Excel automation skills with these complimentary resources:
- Developer’s Guide – https://docs.aspose.com/cells/net/
- Online Demo & Converter – https://products.aspose.app/cells/family
- API Reference – https://reference.aspose.com/cells/net/
- How‑To Articles – https://blog.aspose.com/categories/aspose.cells-product-family/
Conclusion
Creating a PieExploded chart with Aspose.Cells for .NET is straightforward and fully programmable. The example above demonstrates how to insert data, configure the exploded slice, and fine‑tune visual elements—all without needing Microsoft Excel on the server. Incorporate this pattern into reports, dashboards, or any solution that benefits from highlighted proportional data.
If you have questions or need assistance, reach out on our free support forum.