Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JethroUK©
 
Posts: n/a
Default Auto Scaling in charts

is there a method of clearing font scaling in charts by default (as opposed
to chart-by-chart basis)


  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

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)



  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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\Ex cel\Options

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

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\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

  #4   Report Post  
JethroUK©
 
Posts: n/a
Default

i dont have access to the registry (secured network) - thanx anyway for
useful tip


"Debra Dalgleish" wrote in message
...
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\Ex cel\Options

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

to

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove empty chart plots from linked worksheet charts Lee IT Charts and Charting in Excel 3 January 31st 05 05:31 PM
Auto x range start value, xy charts [email protected] Charts and Charting in Excel 5 January 25th 05 12:49 AM
initial size of new charts bob m Charts and Charting in Excel 1 January 22nd 05 03:19 AM
Auto Scaling of Y-axis Nicole Charts and Charting in Excel 5 January 5th 05 08:33 PM
Auto Resizing of Pie Charts RestlessAde Excel Discussion (Misc queries) 0 December 15th 04 09:53 PM


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"