Visualizing proportional data across categories often calls for a 100 % Stacked 3‑D Bar chart. Such a chart instantly shows the relative contribution of each series while preserving a three‑dimensional look. In this article you will learn how to create a Bar3D100PercentStacked chart in an Excel workbook using C# and Aspose.Cells for .NET.
The article covers:
- C# Excel Library to Create Bar3D100PercentStacked Chart
- Create a Bar3D100PercentStacked Chart in Excel using C#
- Free License Information
- Additional Resources
- Conclusion
- See Also
C# Excel Library to Create Bar3D100PercentStacked Chart
Aspose.Cells for .NET is a comprehensive Excel manipulation library that enables developers to create, modify, and render charts without using Microsoft Office. It supports all chart types available in Excel, including the Bar3D100PercentStacked chart.
Key advantages of using Aspose.Cells:
- Rich API – Full control over chart data, appearance, axes, legends, and more.
- No COM/Interop – Works on any platform that supports .NET Standard/.NET Core.
- High Performance – Handles large workbooks with minimal memory footprint.
- Multiple Formats – Save to XLSX, XLS, CSV, PDF, PNG, and other formats.
Getting started is straightforward:
PM> Install-Package Aspose.Cells
Or add the NuGet package via the Visual Studio Package Manager UI.
Create a Bar3D100PercentStacked Chart in Excel using C#
Below is a complete, ready‑to‑run C# example that:
- Creates a new workbook.
- Populates sample data (Quarterly sales of three products).
- Inserts a Bar3D100PercentStacked chart.
- Customises titles, axes, and visual style.
- Saves the workbook to Bar3D100PercentStacked_Output.xlsx.
What the code does
| Step | Action |
|---|---|
| 1 | Creates an empty workbook and renames the first worksheet. |
| 2 | Writes a small data set that represents quarterly sales for three products. |
| 3 | Inserts a Bar3D100PercentStacked chart, binds the data range, sets titles, and enables percentage data labels. |
| 4 | Saves the resulting workbook as an XLSX file, ready to be opened in Excel. |
Running the program produces a workbook where the chart displays each quarter as a 100 % stacked bar, with each product’s contribution shown as a distinct colored segment.
Get a Free License
To try Aspose.Cells without restrictions, obtain a temporary free license from the Aspose temporary license page. The temporary license removes evaluation watermarks and enables full API access for a limited period.
Bar3D100PercentStacked Chart: 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
A Bar3D100PercentStacked chart is an effective way to illustrate proportional data while retaining a three‑dimensional visual style. With Aspose.Cells for .NET, creating such a chart is as simple as populating data, defining the chart type, and tweaking a few properties. The provided example can be directly integrated into any .NET application, enabling you to generate professional Excel reports automatically.
If you encounter any issues or have further questions, visit our free support forum for assistance.