Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Scaling in charts
is there a method of clearing font scaling in charts by default (as opposed
to chart-by-chart basis) |
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
Auto x range start value, xy charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel | |||
Auto Scaling of Y-axis | Charts and Charting in Excel | |||
Auto Resizing of Pie Charts | Excel Discussion (Misc queries) |