Location Method Example

This example moves the embedded chart to a new chart sheet named "Monthly Sales."

Worksheets(1).ChartObjects(1).Chart _
    .Location xlLocationAsNewSheet, "Monthly Sales"