Application.Charts property (Excel)

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



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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.