Chart.Location method (Excel)

Moves the chart to a new location.

Syntax

expression.Location (Where, Name)

expression An expression that returns a Chart object.

Parameters

Name	Required/Optional	Data type	Description
Where	Required	XlChartLocation	Where to move the chart.
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.

Return value

The new Chart at the new location. Note that the Location method deletes the old chart and creates a new one in the new location. As a result, the old chart is invalidated and subsequent operations on it is not well defined.

Example

This example moves the embedded chart to a new chart sheet named Monthly Sales, and assigns the new chart to newChart.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.