ChartObject.MoveToNewChartSheet(String) Method
Moves the current chart to a separate chart sheet.
Namespace: DevExpress.Spreadsheet.Charts
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
Parameters
| Name | Type | Description |
|---|---|---|
| name | String | A String value that specifies the name of the new chart sheet. |
Returns
| Type | Description |
|---|---|
| ChartSheet | A newly created ChartSheet or null (Nothing in Visual Basic), if a chart sheet cannot be created. |
Remarks
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.
Example
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.
Note
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheet-chart-api-e5222
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
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the MoveToNewChartSheet(String) method.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.