Location Method

Applies To

Chart object.

Description

Moves the chart to a new location.

Syntax

expression.Location(Where, Name)

expression Required. An expression that returns a Chart object.

Where Required Long. Where to move the chart. Can be one of the following XlChartLocation constants: xlLocationAsNewSheet, xlLocationAsObject, or 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"