Autoscaling fonts in charts
2008-02-22 Charts 1 61
When you create a new chart in Excel most elements in the chart will have the font autoscale property activated.
This is for many a really annoying setting.
To disable this behavior you can make a change to the Registry:
Navigate to the following location in the Registry (depending on your Office version):
Office 97: HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel Office 2000: HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options Office XP (2002): HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options Office 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\OptionsAdd a new key of the type DWORD and name it AutoChartFontScaling.
Set the Value Data equal to "0" (zero)
Note! Don't try to edit any Registry settings if you don't know what you are doing. If you do anything wrong you might have to re-install the computers operating system and other software.
Yayat Drajat | 2009-05-16 02:49:57 (GMT)
The greatest excel site... I love it. Many thanks~