This web page has some macros that disable font autoscaling:
http://www.geocities.com/jonpeltier/.../FixFonts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

ola wrote:

It's an Excel limitation. You can get around it for many size projects by using the solution below. Note that you may need to copy a worksheet out to another book temporarily in order to eliminate the error message long enough to go into each graph and de-select the auto-scale option. Then you'll have to scale the fonts in each chart. It's time consuming, but does the trick.

http://pubs.logicalexpressions.com/P...?ID=209#jon025