Share via

Charts Collection

  • Article
Excel Developer Reference

A collection of all the chart sheets in the specified or active workbook.

Remarks

Each chart sheet is represented by a Chart object. This does not include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the Chart or ChartObject topics.

Example

Use the Charts property to return the Charts collection. The following example prints all chart sheets in the active workbook.

Visual Basic for Applications 
  
    Charts.PrintOut

Use the Add method 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.

Visual Basic for Applications 
  
    Charts.Add After:=Worksheets("Sheet1")

You can combine the Add method with the ChartWizard method 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.

Visual Basic for Applications 
  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.

Visual Basic for Applications 
  
    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.

See Also