Description
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.
C#
vb.net
Parameters
chartLocation
Chart.ChartLocation.ChartAsSheet or Chart.ChartLocation.ObjectInSheet.sheetIndex
The 0-based index of the worksheet to move the chart to or the index of the chartsheet to insert.Exceptions
IndexOutOfRangeException
An IndexOutOfRangeException will be thrown ifsheetIndex is less than 0 or greater than the total number of worksheets.
ArgumentException
An ArgumentException will be thrown ifchartLocation is ObjectInSheet but the sheet at index sheetIndex is actually a Chartsheet.
Remarks
If chartLocation is ChartAsSheet, this method will create a new Chartsheet at sheetIndex that contains the chart.
If chartLocation is ObjectInSheet, this method will move the chart into the worksheet at sheetIndex, maintaining the original chart position.
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.
