Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Location Method [Excel 2003 VBA Language Reference]

Office 2003

Moves the chart to a new location. Chart object.

expression.Location(Where, Name)

expression Required. An expression that returns one of the objects in the Applies To list.

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"
		


Applies to | Chart Object


Show: