Hi,

For information on the dynamic ranges have a read of Jon Peltier's page
http://peltiertech.com/Excel/Charts/Dynamics.html

Depending on which stock chart you want you will need 3 to 5 named ranges.

Cheers
Andy

Joseph Sayah wrote:
I would like to create a swing chart (stock chart) with a dynamic range that
grows as more data is added.

Any ideas?

Thank You
Joe

--

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