Visualizing proportional data with a 100 % stacked cylinder chart provides an intuitive, three‑dimensional view of how categories contribute to a whole. In this article you will learn how to create a Cylinder100PercentStacked chart in Excel using C# and Aspose.Cells for .NET. Whether you are building a financial dashboard, an engineering report, or any data‑driven application, the example below shows you how to generate a ready‑to‑publish chart with just a few lines of code.

This article covers the following topics:

C# Excel Library to Create Cylinder100PercentStacked Charts

Aspose.Cells for .NET is a comprehensive Excel manipulation library that enables developers to create, modify, and render Excel files without Microsoft Office. It fully supports the Cylinder100PercentStacked chart type, allowing you to produce high‑quality, three‑dimensional stacked charts programmatically.

Key features that make Aspose.Cells ideal for chart generation:

  • Rich Chart API – Over 50 chart types, including 3‑D and statistical charts.
  • Full Format Support – Create XLSX, XLS, CSV, PDF, PNG, JPEG, and more.
  • High Performance – Process large workbooks with minimal memory footprint.
  • No COM/Interop Dependencies – Works in server‑side, cloud, and container environments.

Getting Started

  1. Download the latest release from the Aspose.Cells .NET downloads page.

  2. Install the NuGet package:

    PM> Install-Package Aspose.Cells

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

Now you are ready to create a Cylinder100PercentStacked chart.

Create a Cylinder100PercentStacked Chart in Excel using C#

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

  1. Creates a new workbook.
  2. Populates sample data representing quarterly sales for three product lines.
  3. Adds a Cylinder100PercentStacked chart.
  4. Customizes the chart title, axes, and legend.
  5. Saves the workbook to CylinderChart_Output.xlsx.

Note – The chart type is referenced via the ChartType.Cylinder100PercentStacked enumeration.

Explanation of the Code

StepWhat It Does
1️⃣Instantiates a new Workbook and retrieves the first Worksheet.
2️⃣Writes header rows and sample data (quarters and three product series).
3️⃣Adds a Cylinder100PercentStacked chart (ChartType.Cylinder100PercentStacked).
4️⃣Adds three data series, each linked to a column of numeric values.
5️⃣Customizes the legend, axes titles, 3‑D shading, and series colors.
6️⃣Saves the workbook as CylinderChart_Output.xlsx.

Running the program produces an Excel file that contains a fully functional 3‑D 100 % stacked cylinder chart ready for further editing or direct distribution.

Get a Free License

Aspose offers a temporary free license for evaluation purposes. Obtain yours from the Aspose temporary license page. Using a temporary license removes all evaluation watermarks and lets you explore the full feature set of Aspose.Cells for .NET.

Free Resources

Continue expanding your Excel automation expertise with these free resources:

Conclusion

In this guide we demonstrated how to create a Cylinder100PercentStacked chart in Excel using C# and Aspose.Cells for .NET. The example showcases data preparation, chart creation, series configuration, and visual customization—all with a compact, production‑ready code snippet. Leveraging Aspose.Cells enables you to generate sophisticated, three‑dimensional charts on the server side without needing Microsoft Office.

If you encounter any questions or need further assistance, feel free to visit our free support forum.

See Also