Hiding Charts
 

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.

Hiding Charts
 

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

--
John Mansfield
http://cellmatrix.net





"curious engineer" wrote:

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.