Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

Scrollbar