Visualizing layered data in a three‑dimensional form helps stakeholders quickly grasp the composition of totals across categories. In this article you will learn how to create a CylinderStacked chart—the 3‑D stacked cylinder column chart—in an Excel workbook using C# and Aspose.Cells for .NET. The guide includes a complete, ready‑to‑run code sample and a brief overview of how to tweak an existing chart to a cylinder style.

This article covers the following topics:

C# Excel Library to Create CylinderStacked Charts

Aspose.Cells for .NET is a comprehensive Excel manipulation library that removes the need for Microsoft Office automation. It offers a rich API for creating, editing, and formatting charts programmatically. When working with 3‑D chart types such as the CylinderStacked chart, Aspose.Cells provides full support for chart types, series formatting, axis configuration, and more.

Key advantages of using Aspose.Cells for .NET:

  • Full‑Featured API – Access every Excel feature, including advanced 3‑D chart types.
  • No Office Dependency – Works in server‑side environments without requiring Excel to be installed.
  • High Performance – Handles large workbooks with low memory footprint.
  • Cross‑Platform – Compatible with .NET Framework, .NET Core, and .NET 5/6+.

Installation

PM> Install-Package Aspose.Cells

Create a CylinderStacked Chart in Excel using C#

Below is a complete, self‑contained example that creates a workbook, populates it with sample data, adds a CylinderStacked chart, customises its appearance, and saves the file.

Step‑by‑Step Explanation

  1. Create a new workbook and obtain the first worksheet.
  2. Insert sample data – categories (Q1‑Q4) and three product series.
  3. Add a chart using ChartType.CylinderStacked.
  4. Define the data range for the chart and set the category axis.
  5. Customize chart elements (title, legend, axes titles, 3‑D rotation).
  6. Save the workbook to an Excel file.

Complete C# Code

Explanation of Key Lines

  • ChartType.CylinderStacked selects the 3‑D stacked cylinder column chart.
  • SetChartDataRange("A1:D5", true) tells Aspose.Cells to treat the first row as series names.
  • chart.NSeries.CategoryData = "A2:A5" maps quarters to the X‑axis.

Get a Free License

Explore Aspose.Cells free temporary licenses to unlock all features during development. Visit the temporary license page to obtain a license key and start building robust Excel solutions without restrictions.

CylinderStacked Chart Excel: Free Resources

Continue your learning journey with these useful resources:

Conclusion

In this article we covered how to create a CylinderStacked chart—a 3‑D stacked cylinder column chart—using Aspose.Cells for .NET. The provided code examples illustrate both creating a brand‑new chart and converting an existing chart to the cylinder style. With Aspose.Cells you can generate sophisticated visualizations completely programmatically, without the need for Microsoft Excel on the server.

If you have questions or need further assistance, feel free to post on the Aspose.Cells support forum.

See Also