Help with dynamic charting technique

[Dheeraj]

Hi,


I tried using dynamic charting technique at below link but when I insert a picture and try to type namedrange, excel doesn't let me do it.


http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/


However, when I copy the picture used in downloaded file from this link, it works.


Please help as I want to use it in a report.


Dheeraj

 

[Dheeraj]

Hi All,


Please help with my query.


Thanks,

Dheeraj

 

[Hui]

Dheeraj


That technique doesn't work well with Excel 2007/10

 

[Dheeraj]

Hi Hui,


Thank you so much for the reply. I checked it again. Yes, it works with Excel 2003 but not working in 2007 version.


Is there any other way to get this/such functionality in Excel 2007?


Thanks again,

Dheeraj