Hi all:
The worksheet that I am working in already has 6 graphs, each on their own sheet. On a summary sheet I was trying to add a drop down box to select the different graphs to show them on the summary sheet. Is there an easy way to do this? I've tried a couple macros but the formatting doesn't work out very well. I was just looking for an easier way to view the graphs on that sheet instead of hyperlinking to each graph.
Thanks!