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

[Phil]

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]

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

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

 

[Tushar Mehta]

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

--
Regards,

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