G Guest Jan 7, 2006 #1 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
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
A Andy Pope Jan 8, 2006 #2 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
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
T Tushar Mehta Jan 11, 2006 #3 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
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
