Page History

Moves the chart to a different worksheet. The method specifies whether the chart should be inserted as an object within the worksheet, or converted to a chart sheet.

 public void MoveChart(ChartLocation chartLocation, System.String sheetName, int sheetIndex)

Public Sub MoveChart(ByVal chartLocation As ChartLocation, ByVal sheetName As String, ByVal sheetIndex As Integer)

Chart.ChartLocation.ChartAsSheet or Chart.ChartLocation.ObjectInSheet.

New name for the sheet to which the chart is moved.

The 0-based index of the worksheet to move the chart to or the index of the chartsheet to insert.

An IndexOutOfRangeException will be thrown if sheetIndex is less than 0 or greater than the number of sheets in the workbook.

An ArgumentException will be thrown if chartLocation is ObjectInSheet and the sheet at sheetIndex is a Chartsheet, if chartLocation is ChartAsSheet and there is already as sheet named sheetName or if chartLocation is ChartAsSheet and sheetName is not a valid worksheet name. See Worksheet.Name for a description of what is a valid worksheet name.

An ArgumentNullException will be thrown if chartLocation is ChartAsSheet and sheetName is null.

If chartLocation is ChartAsSheet, this will create a Chartsheet at sheetIndex named sheetName and move the chart to the chartsheet.

If chartLocation is ObjectInSheet, this will move the chart to the worksheet at sheetIndex.

In either case, the chart's formulas (for series data, axis titles, etc) will maintain their original references.

If the chart is inside a chartsheet before calling this method, that chartsheet is deleted.