ChartSheetBase.Location Method (XlChartLocation, Object)

 

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

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

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

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

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");
}
Return to top
Show: