Worksheet.ChartObjects (Excel)

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

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.

ChartObjects (Index)

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

Dim cos As ChartObjects
Set cos = ActiveSheet.ChartObjects()