Chart.Location Method

Article
01/07/2014

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

Where
Type: Microsoft.Office.Interop.Excel.XlChartLocation

XlChartLocation. Where to move the chart.

Name
Type: System.Object

The name of the sheet where the chart is embedded if Where is xlLocationAsObject or the name of the new sheet if Where is xlLocationAsNewSheet.

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

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Share via