Jethro,

Can you let us know exactly what you mean by font scaling?

If you're trying to shut off the primary Y-axis scaling, you could use a
macro like this:

Sub ShutOffScaling()
   Dim Sht As Worksheet
   Dim Cht As ChartObject
   For Each Sht In ActiveWorkbook.Sheets
       For Each Cht In Sht.ChartObjects
           With Cht.Chart.Axes(xlValue)
               .MinimumScaleIsAuto = False
               .MaximumScaleIsAuto = False
               .MinorUnitIsAuto = False
               .MajorUnitIsAuto = False
           End With
       Next Cht
   Next Sht
End Sub

----
Regards,
John Mansfield
http://www.pdbook.com

"JethroUK©" wrote:

For new charts, you can change a registry setting to make "Off" the
default. There are instructions in the following MSKB article:

   http://support.microsoft.com/default.aspx?id=168650

Warning -- Back up your registry before you make any changes to it!!

If you have Excel 2000, add a new DWORD (AutoChartFontScaling) with
Value Data:0 to

    HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options

For Excel 2002, add a new DWORD (AutoChartFontScaling) with Value Data:0 to

    HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options

JethroUK© wrote: