ChartSheet.Location Method

Moves the Microsoft.Office.Tools.Excel.ChartSheet to a new location.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
  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

  One of the XlChartLocation values that specify where to move the chart.

• Name
  Type: System.Object

  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

Type: Microsoft.Office.Interop.Excel.Chart

Examples

The following code example uses the Location method to move the current Microsoft.Office.Tools.Excel.ChartSheet to a new worksheet named "NewSheet".

Private Sub MoveToNewSheet()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

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

    Me.Location(Excel.XlChartLocation.xlLocationAsNewSheet, _
        "NewSheet")
End Sub

private void MoveToNewSheet()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

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

    this.Location(Excel.XlChartLocation.xlLocationAsNewSheet, 
        "NewSheet");
}

.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.

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace