Jon Peltier has information on creating dynamic charts:

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


kimw wrote:
I has many charts that use the same spreadsheet for information. How can I
add lines in my spreadsheet and have the charts automatically update?
(currently I go into source data and change the cell number for each one)

Thanks!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html