Visualizing proportional data in a three‑dimensional style can make reports more engaging. The ConicalBar 100% Stacked chart is an eye‑catching way to display how each category contributes to a whole, while also giving a sense of depth. In this article you will learn how to create such a chart in Excel using C# and Aspose.Cells for .NET.

This article covers

C# Excel Library to Create ConicalBar 100% Stacked Charts

Aspose.Cells for .NET is a comprehensive Excel manipulation library that enables developers to create, edit, and render Excel files without Microsoft Office. It provides a rich set of chart types, including the ConicalBar100PercentStacked chart, which is not available in the native Microsoft Interop library.

Key advantages of using Aspose.Cells:

  • Full API Coverage – Access every Excel feature programmatically.
  • High Performance – Process large workbooks quickly and with low memory footprint.
  • No Office Dependency – Runs on any platform that supports .NET.
  • Multiple Output Formats – Save to XLSX, XLS, PDF, PNG, and more.

Getting Started

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

  2. Install via NuGet:

    PM> Install-Package Aspose.Cells

    Tip: The NuGet package includes all required binaries and documentation files.

Create a ConicalBar 100% Stacked Chart in Excel using C#

Below is a complete, ready‑to‑run C# console program that creates a workbook with sample data, adds a ConicalBar100PercentStacked chart, customizes its appearance, and saves the file to disk.

What the code does

StepAction
1️⃣Instantiates a new Workbook and retrieves the first Worksheet.
2️⃣Writes sample quarterly sales data (months in column A, Q1‑Q3 in columns B‑D).
3️⃣Adds a ConicalBar100PercentStacked chart to the sheet.
4️⃣Adds three series – one for each quarter – using Excel‑style range formulas.
5️⃣Sets axis titles, formats the value axis as a percentage, and applies a visual style.
6️⃣Saves the workbook as ConicalBar100PercentStackedChart.xlsx.

Run the program, open the generated Excel file, and you will see a three‑dimensional conical bar chart where each month’s bar is 100 % tall, divided proportionally among the three quarters.

Update an Existing ConicalBar 100% Stacked Chart

Sometimes you need to modify a chart after it has been created (e.g., change the data source, adjust colors, or toggle the legend). The following snippet demonstrates how to load an existing workbook, locate the chart, and make updates.

Key modifications

  • Title – Updated to reflect the new purpose.
  • Colors – Directly set the ForegroundColor of each series.
  • Legend – Relocated to the right side for clearer space utilization.
  • Data Labels – Enabled and formatted as percentages, positioned in the centre of each segment.

Get a Free License

Explore Aspose.Cells without restrictions by requesting a temporary free license from the Aspose temporary license page. The temporary license removes evaluation watermarks and provides full API access for development and testing.

Free Resources

Conclusion

The ConicalBar 100% Stacked chart offers a visually compelling way to represent proportional data across categories while adding a three‑dimensional effect. With just a few lines of C# code, Aspose.Cells for .NET lets you create, customize, and update this chart type programmatically—no Microsoft Office required. Use the examples above as a foundation for building richer analytical reports, dashboards, or automated Excel generation pipelines.

If you encounter any issues or have questions, feel free to visit the Aspose.Cells support forum for assistance.

See Also