Auto Scaling in charts

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

is there a method of clearing font scaling in charts by default (as opposed
to chart-by-chart basis)
 
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
 
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
 
i dont have access to the registry (secured network) - thanx anyway for
useful tip
 
Back
Top