Is there a way to create a drop down to switch between charts (what about pivot charts)? I found this link, but it only works if you can put the entire graph in one cell..
http://chandoo.org/wp/2008/11/05/sel...art-from-many/
Is there a way to create a drop down to switch between charts (what about pivot charts)? I found this link, but it only works if you can put the entire graph in one cell..
http://chandoo.org/wp/2008/11/05/sel...art-from-many/
I would start by asking what you want differently than how the above method works?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I have three pivot charts, but they take up a lot of real estate, so I'd like to create a drop down box (or anything really) that will allow me to switch between them. The above link won't help me.
I suppose you could use VBA to bring over whatever you want instead.
You can modify the hack to use named ranges that cover more than a single cell.
All you need are named ranges for each chart, formula to return named range (associated with dropdown) and linked picture.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks