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

Referencing a defined name to a picture does not work in Excel 2010

J

jdrwowo

New Member
Chandoo,


I am following your example on how to change charts by defining a region with a name "getCharts" in your example and then putting a picture in a cell and putting "=getChart" for the picture in the formula bar. Is there another way to get this to work in 2010?


Thanks for your help,
 
Jdrwowo


Firstly, Welcome to the Chandoo.org Forums


It would have been nice if you had given us the full link to the specific post that your referring too?


However I assume it is this post ?

http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/


The file there works on in Excel 2010

Here is a XLSX version that works ok

https://www.dropbox.com/s/cd0c6wx59pfaw9l/Select-chart-to-display.xlsx?m


From memory you need to be very careful with the structure of the Named Formula as a few of my comments in the post, suggest.
 
You must log in or register to reply here.
Back
Top