Hiding Charts

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inside Base Series Label Showing #N/A 0
Copying embedded charts 1
Multiple Charts-Multiple Tabs 1
Clustered-Stacked-Column Combo Chart With Lines 2
One Chart, Same Data ranges, different source sheets 4
Linking Excel charts in Powerpoint 0
refreshing charts 3
Displaying numerous charts evenly in various worksheets 1

Top