Application.Charts Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns a Sheets collection that represents all the chart sheets in the active workbook.

expression .Charts

expression A variable that represents an Application object.

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