Share via


Chart.Location Method

Moves the Chart control to a new location.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Function Location ( _
    Where As XlChartLocation, _
    Name As Object _
) As Chart
Chart Location(
    XlChartLocation Where,
    Object Name
)

Parameters

Return Value

Type: Microsoft.Office.Interop.Excel.Chart

Remarks

If you want to move a chart to another position on a sheet, use the Top property and Left property of the ChartArea. You can get the ChartArea object of the Chart by using the ChartArea property.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Examples

The following code example creates a Chart and then uses the Location method to move the chart to a new sheet named "Sales".

Private Sub MoveChartToNewSheet()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    Chart1.Location(Excel.XlChartLocation.xlLocationAsNewSheet, "Sales")
End Sub
private void MoveChartToNewSheet()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;

    chart1.Location(Excel.XlChartLocation.xlLocationAsNewSheet, 
        "Sales");
}

.NET Framework Security

See Also

Reference

Chart Interface

Microsoft.Office.Tools.Excel Namespace