|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)
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.