This topic has not yet been rated - Rate this topic

ChartSheet.Location Method

Visual Studio 2010

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

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

Syntax

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

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD