Macro to hide/unhide chart

[BSCIEddy]

Hi all,

second post in 2 days, I'm glad there are people out there who are so willing to help. Here's my conundrum, I have a fair few data sets for which each has a chart, I'm currently trying to create a macro for each data set that, when clicked once will show the chart and when clicked again it will hide the chart.

I do not want to hide/show all of charts in the sheet, just individual charts, each with a corresponding macro button doing what I said above.

Your help would be greatly appreciated! Thank you in advance!

Eddy

[tigertiger]

Hi all,


I do not want to hide/show all of charts in the sheet, just individual charts, each with a corresponding macro button doing what I said above.

Eddy

Plz see the link, it may be useful for you
http://chandoo.org/wp/2008/11/05/sel...art-from-many/