Chart.Location (Excel)

Moves the chart to a new location.

Location (Where, Name)

Dim chrLocation As Chart
Set chrLocation = ActiveChart.Location(Where:=xlLocationAsNewSheet)

Arguments

The following argument is required

Where (XlChartLocation) - Where to move the chart.

Possible return values are xlLocationAsNewSheet - Chart is moved to a new sheet, xlLocationAsObject - Chart is to be embedded in an existing sheet, xlLocationAutomatic - Excel controls chart location.

Optional arguments

The following argument is optional

Name (String) - 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.