Share via


Charts Interface

A collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.

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

Syntax

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

Remarks

Use the Charts property to return the Charts collection. Use the Add method to create a new chart sheet and add it to the workbook.

You can combine the Add method with the ChartWizard method to add a new chart that contains data from a worksheet.

Use Charts(index), where index is the chart sheet index number or name, to return a single Chart object.

The Sheets collection contains all the sheets in the workbook (both chart sheets and worksheets). Use Sheets(index), where index is the sheet name or number, to return a single sheet.

See Also

Reference

Charts Members

Microsoft.Office.Interop.Excel Namespace