We help IT Professionals succeed at work.

Excel 2010 Dynamic charts  - Not working with named ranges

MrDavidThorn
MrDavidThorn used Ask the Experts™
on
Hi Experts

I have followed the guide (http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html)for creating charts based upon dynamic named ranges, problem is that I cant enter my dynamic range (chartvalue1,chartvalue2,chartname) - into the chart series - it returns an error,  - I have even set the named range chartvalue2 to a static range and I still cant ref it in the chart series,

Iv included an example so the above makes sense!

Many thanks
Example.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2011
Commented:
Right-click the chart, choose Select Data, edit the series and alter the values to
=Workings!ChartValue1
Most Valuable Expert 2011
Top Expert 2011

Commented:
Note: if you have 2007, avoid using named ranges that start with the word Chart.

Author

Commented:
Does this include Excel 2010
Most Valuable Expert 2011
Top Expert 2011

Commented:
No - it works fine in your file with 2010.