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 new Chartsheet at sheetIndex and move the chart to it.

If chartLocation is ObjectInSheet, this will move the chart to the worksheet at sheetIndex, using anchor to define its position within the sheet.

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