Export (0) Print
Expand All

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()

public interface Charts
public interface Charts
public interface Charts

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.


Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft