Is there way I can automatically have Excel change the scale om a.
 

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?

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

For a ready-made solution, see AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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?