Edit

Share via

Application.Charts property (Excel)

  • Article

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

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.