Chart Range

[En. Adel]

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]

Hi,

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

Cheers
Andy