ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Autoscaling fonts in charts

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

Add a new key of the type DWORD that you name AutoChartFontScaling.
Set the Value Data 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.


Document last updated 2008-02-22 20:58:11      Printerfriendly version


Erlandsen Data Consulting   
Excel & VBA Tips   Copyright ©1999-2018    Ole P. Erlandsen   All rights reserved
E-mail Contact Address