Page History

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.