This documentation is archived and is not being maintained.
A collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a
object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the Chart object. ChartObject
public interface Charts : IEnumerable
property to return the Charts Charts collection. Use the method to create a new chart sheet and add it to the workbook. Add
You can combine the
method with the Add method to add a new chart that contains data from a worksheet. ChartWizard
Charts( index), where index is the chart sheet index number or name, to return a single Chart object.
collection contains all the sheets in the workbook (both chart sheets and worksheets). Use Sheets Sheets( index), where index is the sheet name or number, to return a single sheet.