• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Interactive Charts - Linked Pictures [SOLVED]

C

Casie

New Member
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 paste as a linked picture, everything works fine. However, when I assign a tag to that chart (=selChart), it converts the linked picture of the chart to a linked picture of the actual data. Everything else works fine - any idea how I get around this so that the linked picture is of the chart?


Thanks!

C
 
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 click on the picture and say "=selchart" it will convert back to linked picture of the actual data, and everything will work fine. Any ideas on why it will not remain as an image of the graph?


Thanks again!
 
Hi Casie ,


As far as I know , the charts have to be placed in blank areas of the worksheet , and the definition has to use the ranges within which the charts are placed e.g. suppose your chart1 is placed in a vacant area of the worksheet K6:R27 , and chart2 is placed in another vacant area Z3:AG22 , then your named range selChart will refer to =Choose(Output!$E$2,$K$6:$R$27,$Z$3:$AG$22).


However , there was another question on something like this a few days back here :


http://chandoo.org/forums/topic/linked-pictures


You may find it helpful.


Narayan
 
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.


Cheers :)

Casie
 
You must log in or register to reply here.
Back
Top