Chart.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 collection) on the sheet.

This method isn't equivalent to the Charts property of the Workbook object. This method returns embedded charts; the Charts property returns chart sheets. Use the Chart property of the ChartObject object 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 = ActiveChart.ChartObjects()