This documentation is archived and is not being maintained.

_Worksheet.ChartObjects Method 

Returns an object that represents either a single embedded chart (a ChartObject object) or a collection of all the embedded charts (a ChartObjects object) on the sheet.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim Index As Object
Dim returnValue As Object
Dim _Worksheet1 As _Worksheet
returnValue = _Worksheet1.ChartObjects(Index)

object ChartObjects(
	[In, Optional] object Index
public System.Object ChartObjects(
	/*in*/System.Object Index
function ChartObjects(
	 Index : Object
) : Object;



Optional Variant. The name or number of the chart. This argument can be an array to specify more than one chart.

This method isn't equivalent to the Charts property. This method returns embedded charts; the Charts property returns chart sheets. Use the Chart property to return the Chart object for an embedded chart.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms