expression.Location(Where, Name)
expression Required. An expression that returns one of the objects in the Applies To list.
Where Required XlChartLocation. Where to move the chart.
| XlChartLocation can be one of these XlChartLocation constants. |
| xlLocationAsNewSheet |
| xlLocationAsObject |
| xlLocationAutomatic |
Name Optional Variant; required if Where is xlLocationAsObject. The name of the sheet where the chart will be embedded if Where is xlLocationAsObject or the name of the new sheet if Where is xlLocationAsNewSheet.
Example
This example moves the embedded chart to a new chart sheet named "Monthly Sales."
Worksheets(1).ChartObjects(1).Chart _
.Location xlLocationAsNewSheet, "Monthly Sales"