Charts object (Excel)
A collection of all the chart sheets in the specified or active workbook.
Use the Charts property of the Workbook object to return the Charts collection. The following example prints all chart sheets in the active workbook.
Use the Add method of the ChartObjects object to create a new chart sheet and add it to the workbook. The following example adds a new chart sheet to the active workbook and places the new chart sheet immediately after the worksheet named Sheet1.
You can combine the Add method with the ChartWizard method of the Chart object to add a new chart that contains data from a worksheet. The following example adds a new line chart based on data in cells A1:A20 on the worksheet named Sheet1.
With Charts.Add .ChartWizard source:=Worksheets("Sheet1").Range("A1:A20"), _ Gallery:=xlLine, Title:="February Data" End With
Use Charts (index), where index is the chart-sheet index number or name, to return a single Chart object. The following example changes the color of series 1 on chart sheet 1 to red.
Charts(1).SeriesCollection(1).Format.Fill.ForeColor.RGB = rgbRed
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.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.