Charts Property [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
Application.Charts Property
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.

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

See Also