Chart.Location Method

  • Article
Excel Developer Reference

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
Chart

Example

This example moves the embedded chart to a new chart sheet named "Monthly Sales."

Visual Basic for Applications 
  Worksheets(1).ChartObjects(1).Chart _
    .Location xlLocationAsNewSheet, "Monthly Sales"

See Also