Page History

...

Description

Excerpt
Moves the chart to a different worksheet. The method specifies whether the chart should be inserted as an object within the worksheet, or converted to a chart sheet.

Signature

	C#
	C#

 public void MoveChart(ChartLocation chartLocation, System.String sheetName, int sheetIndex)
{signature}{signature:

}

Signature

	vb.net


	vb.net

Public Sub MoveChart(ByVal chartLocation As ChartLocation, ByVal sheetName As String, ByVal sheetIndex As Integer)
{signature}
{parameters}
{param:chartLocation}[

Parameters

Param

	chartLocation
	chartLocation

Chart.ChartLocation.ChartAsSheet

|Chart.ChartLocation#ChartAsSheet]

or

[

Chart.ChartLocation.ObjectInSheet

|Chart.ChartLocation#ObjectInSheet].{param} {param:sheetName}New name for the sheet to which the chart is moved.{param} {param:sheetIndex}The 0\-based index of the worksheet to move the chart to or the index of the chartsheet to insert.{param} {exceptions} {exception:IndexOutOfRangeException} An IndexOutOfRangeException will be thrown if {{sheetIndex}} is less than 0 or greater than the number of sheets in the workbook. {exception} {exception:ArgumentException} An ArgumentException will be thrown if {{chartLocation}} is {{ObjectInSheet}} and the sheet at {{sheetIndex}} is a {{Chartsheet}}, if {{chartLocation}} is {{ChartAsSheet}} and there is already as sheet named {{sheetName}} or if {{chartLocation}} is {{ChartAsSheet}} and {{sheetName}} is not a valid worksheet name. See [{{Worksheet.Name}}|Worksheet.Name] for a description of what is a valid worksheet name. {exception} {exception:ArgumentNullException} An ArgumentNullException will be thrown if {{chartLocation}} is {{ChartAsSheet}} and {{sheetName}} is null. {exception} {remarks} If {{chartLocation}} is {{ChartAsSheet}}, this will create a {{Chartsheet}} at {{sheetIndex}} named {{sheetName}} and move the chart to the chartsheet. If {{chartLocation}} is {{ObjectInSheet}}, this will move the chart to the worksheet at {{sheetIndex}}. In either case, the chart's formulas (for series data, axis titles, etc) will maintain their original references. If the chart is inside a chartsheet before calling this method, that chartsheet is deleted. {remarks} {scrollbar}

.

Param

	sheetName
	sheetName

New name for the sheet to which the chart is moved.

Param

	sheetIndex
	sheetIndex

The 0-based index of the worksheet to move the chart to or the index of the chartsheet to insert.

Exceptions

Exception

	IndexOutOfRangeException
	IndexOutOfRangeException

An IndexOutOfRangeException will be thrown if sheetIndex is less than 0 or greater than the number of sheets in the workbook.

Exception

	ArgumentException
	ArgumentException

An ArgumentException will be thrown if chartLocation is ObjectInSheet and the sheet at sheetIndex is a Chartsheet, if chartLocation is ChartAsSheet and there is already as sheet named sheetName or if chartLocation is ChartAsSheet and sheetName is not a valid worksheet name. See Worksheet.Name for a description of what is a valid worksheet name.

Exception

	ArgumentNullException
	ArgumentNullException

An ArgumentNullException will be thrown if chartLocation is ChartAsSheet and sheetName is null.

Remarks

If chartLocation is ChartAsSheet, this will create a Chartsheet at sheetIndex named sheetName and move the chart to the chartsheet.

If chartLocation is ObjectInSheet, this will move the chart to the worksheet at sheetIndex.

In either case, the chart's formulas (for series data, axis titles, etc) will maintain their original references.

If the chart is inside a chartsheet before calling this method, that chartsheet is deleted.

Scrollbar

Space Shortcuts

Page tree

Versions Compared

Old Version 7

New Version Current

Key