Visualizing proportionate data across categories becomes effortless with a Cylindrical Bar 100 % Stacked chart. This chart type shows how each component contributes to the whole, while the cylindrical style adds a modern, three‑dimensional look. In this guide you will learn how to create such a chart programmatically with Aspose.Cells for .NET using C#. The provided code can be compiled and run without any additional dependencies, enabling you to embed high‑quality charts directly into your Excel automation workflows.

The article covers the following topics:

C# Excel Library to Create CylindricalBar100PercentStacked Charts

Aspose.Cells for .NET is a robust Excel manipulation library that lets developers create, modify, and format Excel files without Microsoft Office installed. It offers a comprehensive API for working with worksheets, cells, formulas, and a wide variety of chart types—including the CylindricalBar100PercentStacked chart.

Key advantages of using Aspose.Cells for chart generation:

  • Rich Chart Type Support – Over 50 native Excel chart types are available out‑of‑the‑box.
  • Full Formatting Control – Customize series, axes, titles, legends, colors, and 3‑D effects.
  • High Performance – Process large workbooks efficiently with minimal memory overhead.
  • No COM Dependencies – Runs in any .NET environment (desktop, server, cloud).

To start using Aspose.Cells in your .NET project:

  1. Download the latest release from the Aspose.Cells releases page.

  2. Install the NuGet package:

    PM> Install-Package Aspose.Cells

Create a CylindricalBar100PercentStacked Chart in Excel using C#

Below is a complete, ready‑to‑run example that demonstrates how to:

  1. Create a new workbook.
  2. Populate sample data representing quarterly sales for three product lines.
  3. Insert a CylindricalBar100PercentStacked chart.
  4. Apply basic formatting (title, axis labels, colors, 3‑D rotation).
  5. Save the workbook to an XLSX file.

Note: The code uses the ChartType.CylindricalBar100PercentStacked enumeration value, which maps directly to the Excel chart type “Cylindrical Bar 100 % Stacked”.

Explanation of the Code

StepWhat It Does
1Instantiates a new Workbook and retrieves the default worksheet.
2Writes a header row and fills four quarters of sales data for three products.
3Adds a chart of type CylindricalBar100PercentStacked and positions it on the sheet.
4Creates three series (one per product) and links them to the appropriate cell ranges.
5Adjusts 3‑D rotation for visual depth and assigns distinct colors to each series.
6Saves the workbook as an XLSX file that can be opened in Microsoft Excel, Google Sheets, or any other compatible viewer.

Running the program will generate an Excel file containing a Cylindrical Bar 100 % Stacked chart that visually compares each product’s contribution to total quarterly sales.

Get a Free License

If you need a temporary license to evaluate Aspose.Cells, visit the Aspose temporary license page. A free license removes all evaluation restrictions and allows you to explore the full feature set without constraints.

Free Resources

Conclusion

Creating a CylindricalBar100PercentStacked chart with Aspose.Cells for .NET is straightforward and fully programmable. The library abstracts the complexity of Excel’s chart engine, enabling developers to produce polished, 3‑D visualizations with just a few lines of C# code. Use the sample provided as a foundation for building dashboards, financial reports, or any scenario where proportionate data needs to be displayed with a modern aesthetic.

For additional assistance, visit the Aspose.Cells free support forum or reach out via the community channels.

See Also