Hiding Charts

[curious engineer]

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.

 

[John Mansfield]

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