is there a method of clearing font scaling in charts by default (as opposed
to chart-by-chart basis)
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
----
Regards,
John Mansfield
http://www.pdbook.com
"JethroUK©" wrote:
> is there a method of clearing font scaling in charts by default (as opposed
> to chart-by-chart basis)
>
>
>
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:
> is there a method of clearing font scaling in charts by default (as opposed
> to chart-by-chart basis)
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
i dont have access to the registry (secured network) - thanx anyway for
useful tip
"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> 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:
> > is there a method of clearing font scaling in charts by default (as
opposed
> > to chart-by-chart basis)
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks