Hiding Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have worksheets with multiple charts on them. I would like to be able to
hide all of the charts and call each one up when I need it.
 
One solution is to use VBA:

Assuming your worksheet is named "Sheet1" and one of the charts is named
"Cht1", to hide the chart use this macro:

Sub HideChart()
Worksheets("Sheet1").Shapes("Cht1").Visible = False
End Sub

To show the chart, use this macro:

Sub ShowChart()
Worksheets("Sheet1").Shapes("Cht1").Visible = True
End Sub
 
Back
Top