Expand Minimize

Application.Charts Property (Excel)

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
Show:
© 2014 Microsoft