Programming Excel with VBA and .NET

Name

chart.Location(Where, [Name])

Synopsis

Moves the chart to a new worksheet or chart sheet.

Argument	Settings
Where	An xlChartLocation constant that specifies the type of location to move to. Can be one of these settings: xlLocationAsNewSheet, xlLocationAsObject, or xlLocationAutomatic.
Name	The name of the target worksheet or chart sheet.

The Location method removes the chart from its current location and inserts it in the new location. For example, the first procedure in the following code block removes the chart sheet New Chart and inserts the chart as an embedded object on the Start worksheet; the second procedure moves the embedded chart back to a chart sheet:

Sub MoveChartToStart(  )
    Dim chrt As Chart
    Set chrt = Charts("New Chart")
    chrt.Location xlLocationAsObject, "Start"
End Sub
 
Sub MoveChartBack(  )
    Dim chrt As Chart
    Set chrt = Worksheets("Start").ChartObjects(1).Chart
    chrt.Location xlLocationAsNewSheet
    ActiveSheet.Name = "New Chart"
End Sub