Take a look at Jon Peltier's Dynamic Chart link

http://www.peltiertech.com/Excel/Charts/Dynamics.html

That should get you in the direction you want to go.

"lhollen1" wrote:


After I make a chart with existing data, how do I make it so everytime I
update the spread sheet or add data to it, the smae data is
automatically added to the chart without having to go back and choose
chart source and add it that way.


--
lhollen1
------------------------------------------------------------------------
lhollen1's Profile: http://www.excelforum.com/member.php...o&userid=24136
View this thread: http://www.excelforum.com/showthread...hreadid=377748