ChartObjects Interface

A collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet.

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

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("000208D0-0000-0000-C000-000000000046")> _
Public Interface ChartObjects _
    Inherits IEnumerable
'Usage
Dim instance As ChartObjects
[InterfaceTypeAttribute()]
[GuidAttribute("000208D0-0000-0000-C000-000000000046")]
public interface ChartObjects : IEnumerable

Remarks

Each ChartObject object represents an embedded chart. The ChartObject object acts as a container for a Chart object. Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the sheet.

Use the ChartObjects method to return the ChartObjects collection. Use the Add method to create a new, empty embedded chart and add it to the collection. Use the ChartWizard method to add data and format the new chart.

Use ChartObjects(index), where index is the embedded chart index number or name, to return a single ChartObject object.

See Also

Reference

ChartObjects Members

Microsoft.Office.Interop.Excel Namespace