Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

ChartCollection Interface

A collection of Chart objects in a worksheet.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

public interface ChartCollection :
    ISimpleCollection<Chart>,
    IEnumerable<Chart>,
    IEnumerable,
    ICollection

The following members return ChartCollection objects:

#Remarks

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