Automatically Adding Data to Charts

[lhollen1]

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

 

[Guest]

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.