Macro to hide graph

[MarioLamaa]

Hi, is there any way to make a macro which would hide a graph depending on drop down selection. To give you an idea of how I want to use it I have 3 graphs for each drop down however only some of them are relevant to the selection and want the irrelevant ones to be hidden. I know I can hide columns however this wont work in the specific file I am building without crashing other data. Thanks

[Andy Pope]

you can set the visible property of the chartobject

Please Login or Register  to view this content.

[MarioLamaa]

How could I then link this to the drop down list? Because certain graphs I would like to be shown depending on what option the user chooses, and there are quite a few options.

[Andy Pope]

without seeing or at least explaining a lot more it's hard to suggest anything that would be relevant above what has already been posted.

Post example workbook and detail what is suppose to happen

[MarioLamaa]

I've actually managed to do it and solve the problem, but thanks for your help!