Visualizing data in three dimensions can make trends stand out and add a professional polish to your reports. In this guide, you’ll discover how to create a CylindricalColumn3D chart in Excel using C# with Aspose.Cells for .NET. The example covers data preparation, chart creation, styling, and saving the workbook—all with concise, production‑ready code.

This article covers the following topics:

C# Excel Library to Create CylindricalColumn3D Charts

Aspose.Cells for .NET is a powerful, fully managed Excel manipulation library that enables developers to create, modify, and render Excel files without Microsoft Office. It supports a rich set of chart types, including the CylindricalColumn3D chart, which renders classic column charts with a cylindrical 3‑D appearance.

Key benefits when using Aspose.Cells for chart generation:

  • No COM Interop – Works on any platform that supports .NET.
  • Full Chart API – Set chart type, data ranges, axes, legends, and detailed formatting.
  • High‑Performance – Handles large datasets efficiently.
  • Multiple Export Formats – Save as XLSX, PDF, PNG, JPEG, and more.

Getting started is simple:

  1. Download the library from the official releases page.

  2. Install it via NuGet:

    PM> Install-Package Aspose.Cells

Create a CylindricalColumn3D Chart in Excel using C#

Below is a complete, self‑contained C# console application that demonstrates how to:

  1. Create a new workbook.
  2. Populate sample sales data.
  3. Add a CylindricalColumn3D chart.
  4. Customize the chart’s title, axes, colors, and 3‑D rotation.
  5. Save the workbook as an XLSX file.

Explanation of Key Steps

StepPurpose
1Instantiates a new Workbook and obtains the first Worksheet.
2Populates the sheet with month names and quarterly sales figures.
3Adds a CylindricalColumn3D chart positioned between rows 8‑28 and columns 0‑10.
4Sets the data range (A1:E7) and assigns category (X‑axis) data to the month column.
5Formats the chart title, 3‑D rotation, axes titles, color style, and enables data labels.
6Saves the workbook as CylindricalColumn3DChart_Output.xlsx.

Running the program produces an Excel file with a sleek cylindrical 3‑D column chart that clearly visualizes quarterly sales trends.

Get a Free License

Aspose.Cells requires a license for full functionality. You can request a temporary free license to evaluate the product without evaluation watermarks:

  • Visit the Aspose temporary license page.
  • Follow the simple registration steps.
  • Replace the placeholder license code in your project (if you need to apply it programmatically) with the file you receive.
// Example of loading a temporary license file
var license = new Aspose.Cells.License();
license.SetLicense("Aspose.Cells.lic");

Free Resources

Conclusion

Creating a CylindricalColumn3D chart with Aspose.Cells for .NET is straightforward and highly customizable. The library abstracts the low‑level XML handling, allowing you to focus on data and presentation. Use the provided sample code as a foundation and adapt it to your specific reporting scenarios—whether you need additional series, custom colors, or dynamic data sources.

For any questions or assistance, feel free to visit the free support forum: https://forum.aspose.com/c/cells/9.

See Also