Moves the current chart to a separate chart sheet.
A String value that specifies the name of the new chart sheet.
A newly created ChartSheet or null (Nothing in Visual Basic), if a chart sheet cannot be created.
When naming a chart sheet, take into account the following constraints:
- A chart sheet name must not be equal to a name that is already contained in the collection of existing sheets (IWorkbook.Sheets).
- A chart sheet name must not exceed 31 characters.
- A chart sheet name must not contain the following symbols: , /, ?, :, *, [ or ]
- A chart sheet name must not start and end with a single quote (‘).
- A chart sheet name must not be an empty string.
The following example demonstrates how to move an existing chart from a worksheet to a separate chart sheet. To do this, call the ChartObject.MoveToNewChartSheet method for a chart you wish to move.
To transfer a chart back to the worksheet containing the source data, use the ChartObject.MoveToWorksheet method.
Dim worksheet As Worksheet = workbook.Worksheets("chartTask1") ' Create an embedded chart on the worksheet. Dim chart As Chart = worksheet.Charts.Add(ChartType.Pie, worksheet("B2:C7")) chart.TopLeftCell = worksheet.Cells("E2") chart.BottomRightCell = worksheet.Cells("K15") ' Move the chart to a chart sheet. Dim chartSheet As ChartSheet = chart.MoveToNewChartSheet("Chart") workbook.ChartSheets.ActiveChartSheet = chartSheet