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)
Usage
Public Class hartsImplementation
Implements Charts
End Class
Dim hartsImplementation1 As New hartsImplementation()
Syntax
Public Interface Charts
public interface Charts
public interface class Charts
public interface Charts
public interface Charts
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.
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000
Target Platforms
See Also
Reference
Microsoft.Office.Interop.Excel Namespace