Visualizing proportional data across multiple categories is a common requirement in business reporting. A Column3D100PercentStacked chart shows each data series as part of a whole, stacked in a three‑dimensional column, and normalizes each column to 100 %. This guide walks you through creating such a chart in Excel using C# and Aspose.Cells for .NET. The solution is fully code‑driven, requires no Excel installation, and can be saved to XLSX, PDF or image formats.

This article covers:

C# Excel Library to Create Column3D100PercentStacked Chart

Aspose.Cells for .NET is a high‑performance library that allows developers to create, modify, and render Excel files without Microsoft Office. It provides a rich charting API covering more than 50 chart types, including the Column3D100PercentStacked chart.

Key advantages of using Aspose.Cells for chart creation:

FeatureBenefit
Comprehensive APIFull access to chart types, series, axes, legends, and formatting.
No Excel requiredWorks on any platform that supports .NET (Windows, Linux, macOS).
Multiple output formatsSave as XLSX, XLS, CSV, PDF, XPS, PNG, JPEG, etc.
High fidelity renderingCharts look identical to those created in Microsoft Excel.
Performance‑optimizedHandles large datasets with low memory footprint.

Getting Started

  1. Download the latest Aspose.Cells for .NET from the releases page.

  2. Install via NuGet:

    PM> Install-Package Aspose.Cells

  3. Add a reference to Aspose.Cells in your C# project.

Now you’re ready to generate a 3‑D 100 % stacked column chart programmatically.

Create a Column3D100PercentStacked Chart in Excel using C#

Below is a complete, self‑contained C# example that:

  1. Creates a new workbook.
  2. Populates sample sales data for three products across four quarters.
  3. Adds a Column3D100PercentStacked chart.
  4. Customizes chart title, axis titles, legend, and data labels.
  5. Saves the workbook to an XLSX file.

Explanation of Key Steps

StepWhat it does
Create workbook & worksheetStarts with an empty Excel file and a sheet named SalesData.
Populate dataInserts quarterly sales figures for three products. The layout matches what the chart expects (categories in column A, series in columns B‑D).
Add chartCalls Charts.Add with ChartType.Column3D100PercentStacked. The chart occupies rows 7‑25 and columns 0‑8 on the worksheet.
Add seriesEach product’s data is added as a separate series. The true flag tells Aspose.Cells to pull the series name from the first cell of the range.
Category dataLinks the X‑axis labels (quarter names) to column A.
CustomizeSets titles, moves the legend, and enables data labels that display percentages on each stacked segment.
SaveWrites the workbook to Column3D100PercentStacked_Chart.xlsx. The file can be opened directly in Excel or converted to other formats.

Free Resources

Get a Free License

Start experimenting with Aspose.Cells without cost. Obtain a temporary free license from the Aspose temporary license page. This unlocks the full feature set, removes evaluation watermarks, and allows you to deploy your solution in production after purchasing a permanent license.

// Example of applying a temporary license (place this at the beginning of your app)
var license = new Aspose.Cells.License();
license.SetLicense("Aspose.Total.NET.lic"); // Path to your temporary .lic file

Conclusion

A Column3D100PercentStacked chart provides a clear, visually appealing way to compare the relative contribution of multiple data series across categories. With Aspose.Cells for .NET you can generate such charts programmatically, customize every element, and export the result to a variety of formats—all without requiring Microsoft Excel. Use the provided sample code as a foundation, adapt the data source to your needs, and integrate chart generation into your reporting pipelines.

For further assistance, visit the Aspose.Cells Support Forum: https://forum.aspose.com/c/cells/9

Happy coding!

See Also