Swing Chart with dynamic Range

[Joseph Sayah]

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]

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

 

[Tushar Mehta]

In addition to Andy's suggestion, you may also want to check
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions