Visualizing data as a 3‑D 100 % Stacked Area chart helps stakeholders quickly grasp the relative contribution of each series throughout a period. With Aspose.Cells for .NET, you can create this chart type programmatically without requiring Excel to be installed. This guide walks you through the entire process—from setting up the workbook to customizing the chart and finally saving the result.
The article covers:
- C# Excel Library to Create Area3D100PercentStacked Charts
- Create an Area3D100PercentStacked Chart in Excel using C#
- Free Resources
- Conclusion
- See Also
C# Excel Library to Create Area3D100PercentStacked Charts
Aspose.Cells for .NET is a comprehensive Excel manipulation library that enables developers to create, modify, and render Excel files in server‑side environments. It supports the full spectrum of chart types, including the Area3D100PercentStacked chart, which is not directly available through the Excel UI in older versions.
Key advantages of using Aspose.Cells for chart generation:
- Zero dependency on Microsoft Office – works on any platform that supports .NET.
- Rich API surface – full control over chart data, axes, legends, colors, and 3‑D options.
- High performance – efficient handling of large workbooks and data sets.
- Multiple output formats – save as XLSX, PDF, PNG, JPEG, and more.
Getting Started
Download the latest Aspose.Cells for .NET package from the releases page.
Install the NuGet package:
PM> Install-Package Aspose.CellsAdd a reference to
Aspose.Cellsin your .NET project.
Now you are ready to create a 3‑D 100 % Stacked Area chart.
Create an Area3D100PercentStacked Chart in Excel using C#
Below is a complete, ready‑to‑run C# console application that demonstrates how to:
- Create a workbook and populate it with sample data.
- Insert an Area3D100PercentStacked chart.
- Configure series, axes, titles, and style.
- Save the workbook as an XLSX file.
Explanation of the Code
| Step | What It Does |
|---|---|
| 1 | Instantiates a new Workbook and obtains the first worksheet. |
| 2 | Populates the sheet with a small data set that represents quarterly sales for three products. |
| 3 | Adds a chart of type Area3D100PercentStacked and positions it in the worksheet. |
| 4 | Defines the category (X‑axis) range (A2:A6) and the series data range (B2:D6). Each series is given a friendly name. |
| 5 | Adjusts chart style, legend placement, axis titles, and custom colors for each series to make the chart visually appealing. |
| 6 | Saves the workbook as an XLSX file. The generated file can be opened with Excel, LibreOffice, or any viewer that supports the format. |
Run the program, and you will obtain Area3D100PercentStackedChart.xlsx containing a 3‑D 100 % stacked area chart that visualizes the proportional contribution of each product per quarter.
Free 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 3‑D 100 % Stacked Area chart with Aspose.Cells for .NET is straightforward and does not depend on Microsoft Excel. The library provides granular control over every chart element, allowing you to generate professional‑grade visualizations that can be embedded in reports, dashboards, or exported to PDF/PNG for distribution.
Feel free to experiment with additional styling options—such as data labels, custom number formats, or theme colors—to match your corporate branding. If you encounter any challenges, the Aspose community forum and support channels are ready to help.