Back to Devexpress

How to: Remove a Chart Sheet

wpf-119721-controls-and-libraries-spreadsheet-examples-charts-how-to-remove-a-chart-sheet.md

latest1.5 KB
Original Source

How to: Remove a Chart Sheet

  • Jun 07, 2019

To delete a chart sheet from a workbook, remove it from the workbook’s ChartSheetCollection by using the ChartSheetCollection.Remove or ChartSheetCollection.RemoveAt method.

You can also move a chart back to the worksheet containing the source data by using the chart’s ChartObject.MoveToWorksheet method.

View Example

vb
Dim worksheet As Worksheet = workbook.Worksheets("chartTask1")

' Create the first chart sheet.
workbook.ChartSheets.Add()

' Create the second chart sheet.
workbook.ChartSheets.Add(ChartType.Pie, worksheet("B2:C7"))

' Remove the first chart sheet.
workbook.ChartSheets.RemoveAt(0)
csharp
Worksheet worksheet = workbook.Worksheets["chartTask1"];

// Create the first chart sheet.
workbook.ChartSheets.Add();

// Create the second chart sheet.
workbook.ChartSheets.Add(ChartType.Pie, worksheet["B2:C7"]);

// Remove the first chart sheet.
workbook.ChartSheets.RemoveAt(0);