This documentation is archived and is not being maintained.

Application.Charts Property

Office 2007
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



Show: