Dropdown box to select chart

[MrFMC]

Hi all,

Is it possible to have excel display a chart based on a selection from a list data validation rule. I have 20 charts that I want to be able to view, but I don't want to see all of them at once. If there is a non-VBA solution, that would be ideal. Thank you in advance for your help.

Regards,

Charles

 

[Michael M]

Have a look at this thread.
I believe it will do as required.....BUT it will be a VBA solution !!

http://www.mrexcel.com/forum/excel-questions/525495-conditionally-show-hide-charts.html