Visualizing proportional data across multiple categories is a common requirement for business reporting, dashboards, and performance analysis. A Column 100 Percent Stacked chart shows the contribution of each series as a percentage of the total for a given category, making it easy to compare relative values.
In this article you will learn how to generate a Column 100 Percent Stacked chart in an Excel workbook using Aspose.Cells for .NET. The guide includes a complete, compile‑ready C# example and notes on customizing the chart’s appearance.
This article covers the following topics:
- C# Excel Library to Create Column100PercentStacked Chart
- Create a Column100PercentStacked Chart in Excel using C#
- Free License
- Additional Free Resources
- Conclusion
- See Also
C# Excel Library to Create Column100PercentStacked Chart
Aspose.Cells for .NET is a high‑performance Excel manipulation library that enables developers to create, edit, and render Excel files without requiring Microsoft Office. It provides a rich charting API that supports all native Excel chart types, including the Column100PercentStacked chart.
Key benefits of using Aspose.Cells for chart creation:
- Full‑featured API – Access to chart types, series, axes, legends, and formatting.
- No COM Interop – Works on any platform that supports .NET (Windows, Linux, macOS).
- High performance – Efficient handling of large workbooks and data ranges.
- Multiple output formats – Save to XLSX, PDF, PNG, JPEG, and more.
Getting Started
- Download the latest Aspose.Cells for .NET binary from the releases page.
- Install the NuGet package (recommended)
PM> Install-Package Aspose.Cells
- Add a reference to
Aspose.Cellsin your C# project.
Create a Column100PercentStacked Chart in Excel using C#
Below is a complete, self‑contained C# program that:
- Creates a new workbook.
- Populates sample data representing quarterly sales for three product lines.
- Inserts a Column 100 Percent Stacked chart.
- Customizes the chart title, axes, legend, and data labels.
- Saves the workbook as an XLSX file.
Explanation of the Code
| Step | What the code does | Why it matters |
|---|---|---|
| 1 | Creates an empty Workbook and references the first worksheet. | Provides a clean workbook to work with. |
| 2 | Writes a header row and four rows of quarterly sales data for three products. | Supplies the data source required by the chart. |
| 3 | Adds a ChartType.Column100PercentStacked chart and specifies its location on the sheet. | Instantiates the specific chart type we want to demonstrate. |
| 4 | Calls NSeries.Add to bind the data range (B2:D5) and sets CategoryData to the quarter labels (A2:A5). | Links the series and category (X‑axis) data to the chart. |
| 5 | Enables data labels and configures them to display percentages only, moves the legend, and adds an axis title. | Improves readability and makes the chart presentation‑ready. |
| 6 | Saves the workbook as Column100PercentStackedChart.xlsx. | Generates the final Excel file that contains the chart. |
Run the program (e.g., with dotnet run) and open the generated Column100PercentStackedChart.xlsx to see the chart rendered.
Get a Free License
Aspose.Cells offers a temporary free license for evaluation purposes. Visit the temporary license page to obtain a key that removes evaluation watermarks and enables full functionality during development.
Column100PercentStacked Chart: Free Resources
- Developer’s Guide – https://docs.aspose.com/cells/net/
- Online Demo & Conversion Apps – https://products.aspose.app/cells/family
- API Reference – https://reference.aspose.com/cells/net/
- How‑to Articles & Blog Posts – https://blog.aspose.com/categories/aspose.cells-product-family/
Conclusion
Creating a Column 100 Percent Stacked chart with Aspose.Cells for .NET is straightforward and requires only a few lines of code. The library’s fluent API handles data binding, series customization, and chart formatting, allowing you to generate professional, share‑ready Excel reports without needing Microsoft Office installed.
If you encounter any issues or have questions, feel free to post on the Aspose.Cells community forum where both Aspose engineers and fellow developers can assist you.