Swing Chart with dynamic Range
 

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

Swing Chart with dynamic Range
 

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

Swing Chart with dynamic Range
 

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

--
Regards,

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

In article ,
says...
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