Hi!
I am trying to make a chart to change based on a dropdown. I have used the following to do this:
http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/
I could done it, and then I wanted to do it in another sheet, defining another name and I can do it, however when I insert the picture and try to add in the formula bar "=defined name" it returns me "reference is not valid". Do you have any idea why?
Thanks!
I am trying to make a chart to change based on a dropdown. I have used the following to do this:
http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/
I could done it, and then I wanted to do it in another sheet, defining another name and I can do it, however when I insert the picture and try to add in the formula bar "=defined name" it returns me "reference is not valid". Do you have any idea why?
Thanks!
