Hi
Please can someone point me to a solution whereby the chart displayed is as per user selection from a drop-down? I have attached a sample file.
Is 'camera' the best solution?
Thanks for all guidance
Hi
Please can someone point me to a solution whereby the chart displayed is as per user selection from a drop-down? I have attached a sample file.
Is 'camera' the best solution?
Thanks for all guidance
This is a tricky one. To do this I had to change some formatting to put each chart in one big cell. Then I set up a named formula called ShowChart. Then I created an image on the display sheet, and associated with the formula =ShowChart. It uses the value in C7 to determine which cell to show, which brings the chart along with it.
Mate
I don't know if there is an award for 'above and beyond', but if there is, there's one waiting with your name on it.
Thanks and rep added. Star!
You are welcome! I had to dig a little to figure this one out but it was fun and I learned something.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks