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.
Parameters
chartLocation
Chart.ChartLocation.ChartAsSheet or Chart.ChartLocation.ObjectInSheet.sheetName
New name for the sheet to which the chart is moved.Exceptions
ArgumentException
An ArgumentException will be thrown in two cases. First, ifchartLocation
is ChartAsSheet
and a sheet (Worksheet
or Chartsheet
) named sheetName
already exists. Second, if chartLocation
is ObjectInSheet
, and a sheet named sheetName
already exists and is a Chartsheet
.
Remarks
If chartLocation
is ChartAsSheet
, this will create a Chartsheet
named sheetName
at the end of the workbook and move the chart into it.
If chartLocation
is ObjectInSheet
and there is already a worksheet named sheetName
, this will move the chart into that sheet. If there is no such sheet, this will create a new Worksheet
with that name at the end of the workbook and move the chart into it.
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.