Jon Peltier has a couple of techniques that you could use:

http://www.peltiertech.com/Excel/Cha...nkToSheet.html

Phil wrote:
I have an excel file, which I uses to make xy graphs but I change the value
that are plotted. The graph does not rescale by itself so I have to keep on
doing it manually. Is there a way to get Excel to automatically rescale?


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