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

How to: Create a Chart Sheet

This example demonstrates how to create a new chart sheet - a separate sheet in a workbook containing only a chart. To do this, use the ChartSheetCollection.Add method of the Workbook.ChartSheets collection.

To insert a chart sheet at the specified position in the ChartSheetCollection collection, call the ChartSheetCollection.Insert method.

Use the ChartSheet.Chart property to access a chart located on the chart sheet and specify or modify its settings (select chart data, change the chart type and adjust its appearance).

// Create a chart sheet containing a pie chart.
ChartSheet chartSheet = workbook.ChartSheets.Add(ChartType.Pie, worksheet["B2:C7"]);

The image below shows a new chart sheet added to a workbook.

SpreadsheetAPI_CreateChartSheet