No leakage. But I think I fixed the problem. I copied all of the charts to rows f and g and referenced those rows and suddenly it works. No idea why but I won't complain. Thanks for your help! Now if I could only get the conditional formatting to work consistently.
Thanks Luke. That definitely simplifies the formula, but unfortunately it doesn't fix the problem. I am showing the exact same results (it is referring to the range 'charts!'c2:'charts!'e2 when I select "sales" instead of just 'charts!'c2). Really strange.
Hello,
I am trying to conditionally change a chart based on a pull-down menu. I have been following the guide found here with mixed results:
http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/
I am using excel 2010. I have followed the steps outlined and it mostly works but...