Application.Charts Property (Excel)
Returns a Sheets collection that represents all the chart sheets in the active workbook.
Syntax
expression .Charts
expression A variable that represents an Application object.
Example
This example sets the text for the title of Chart1.
With Charts("Chart1")
.HasTitle = True
.ChartTitle.Text = "First Quarter Sales"
End With
This example hides Chart1, Chart3, and Chart5.
Charts(Array("Chart1", "Chart3", "Chart5")).Visible = False