Create BoxWhisker Chart in XLSX Documents via C#

Generate high‑quality BoxWhisker (box‑plot) charts programmatically with Aspose.Cells for .NET – no Microsoft Office required.

Creating a BoxWhisker (box‑plot) chart in an Excel workbook programmatically is simple with Aspose.Cells for .NET. This chart type is ideal for visualising statistical distribution of data – median, quartiles, outliers, etc. The following guide shows how to add a BoxWhisker chart to an XLSX file without requiring Microsoft Excel on the server.

How to create a BoxWhisker chart in XLSX via C#

The steps are straightforward:

Add the Aspose.Cells namespace.
Create a Workbook instance.
Fill a worksheet with the source data.
Insert a chart and set its type to ChartType.BoxWhisker.
Bind the chart to the data range.
(Optional) Customize chart title, style, and axis.
Save the workbook.

System Requirements

Aspose.Cells for .NET runs on any platform that supports .NET Framework 4.0+, .NET Core 2.0+, .NET 5/6/7, Mono, Xamarin, or Azure Functions. No Microsoft Office installation is needed.

Install from the command line: nuget install Aspose.Cells
or via Visual Studio Package Manager: Install-Package Aspose.Cells.
Or download the full package from the Aspose.Cells download page.

Create BoxWhisker Chart – C#

Aspose.Cells is a powerful spreadsheet library that enables developers to create, modify, convert, render and print Excel files across platforms. Its rich charting engine supports over 70 chart types, including the statistical BoxWhisker chart, without any dependency on Microsoft Office.

XLSX What is XLSX File Format?

XLSX is Microsoft’s Open XML spreadsheet format introduced with Office 2007. It is a zip package that stores worksheet data, styles, and chart definitions as XML parts, making it easy to generate and manipulate programmatically.