Skip to main content
.NET Framework 4.5.2+

ChartCollection Interface

A collection of Chart objects in a worksheet.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v22.2.Core.dll


public interface ChartCollection :


Use the Worksheet.Charts property to return the ChartCollection collection.

Use the ChartCollection.Add method to create a new chart and add it to the workbook. The following example adds a new embedded chart to the active worksheet and places the new chart above the cells in the range E2:K15.

The example below demonstrates how to create a 3-D pie chart using the ChartCollection.Add method overload that enables you to specify a CellRange containing chart data.

View Example

Worksheet worksheet = workbook.Worksheets["chartTask1"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Create a pie chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.Pie3D, worksheet["B2:C7"]);
chart.TopLeftCell = worksheet.Cells["E2"];
chart.BottomRightCell = worksheet.Cells["K15"];

// Set the chart style.
chart.Style = ChartStyle.ColorGradient;
See Also