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