Excel Developer Home > Excel Object Model Reference > Application Object > Properties
Returns a Sheets collection that represents all the chart sheets in the active workbook.

expression.Charts

expression   A variable that represents an Application object.

Example

This example sets the text for the title of Chart1.

Visual Basic for Applications
With Charts("Chart1")
    .HasTitle = True
    .ChartTitle.Text = "First Quarter Sales"
End With

This example hides Chart1, Chart3, and Chart5.

Visual Basic for Applications

					Charts(Array("Chart1", "Chart3", "Chart5")).Visible = False