Thanks Narayan!
I'ev tried that and everything now works.
Not sure what the issue was, but when I used the actual cell range of the charts as you suggested rather than the chart names this seemed to do the trick. Must have done something incorrect when naming the charts in the first place...
Hi!
I think I have defiend the range correct - is that the same thing as the "refers to"?
If so, it is:
=Choose(Output!$E$2, Chart1, Chart2)
Where E2 is my linked cell, and Chart 1 and Chart 2 are the names of my charts.
Even if I paste a linked picture into the range, as soon as I...
Hello everyone,
I am using Excel 2010 and building interactive charts for a dashboard. I have followed the instructions from Chandoo on how to do this, but have run into an issue when I try to paste the chart as a linked picture.
When I select the range that contains the chart, copy, and...