Hi,

Have a look at Jon's examples of dynamic charts using named ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

En. Adel wrote:
Hello!
How can I make a chart range in excel changes dynamiclly when values number
changes, meaning the i have my data from external source and it's not always
the same, I just want to make the chart response to how many rows are there.

I hope I was clear, my english is not that much!

Thank you in advanced..

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info