How to create non-resizable font in charts

Excel 2003
When you scale Excel chart, the font of text items is scaled proportionally to the size of the chart. Unfortunately this powerful feature is a big source of a headache. Scaled fonts break formatting consistency, when those charts are being inserted into the Word document or PowerPoint presentation. Fortunately you can turn off auto-scaling for the particular chart item or disable it at all.

Select the text item in the chart (a chart title, axis, legend, and so on), and access the Format dialog box for that item. Click the Font tab and specify the font size. Remove the check mark from the Auto Scale check box.

To turn off auto scaling for all text items in the chart, access the Format Chart Area dialog box, choose the Font tab, and remove the check mark from Auto Scale. For best results, do this before making any font formatting changes in the chart - otherwise, all text elements will be formatted identically, and you'll probably need to make additional adjustments.

Font in Excel 2003

To turn off auto scaling permanently, you need to make a change to the Windows registry. Use the Windows regedit.exe program and navigate to this key (the "11.0" part will vary, depending on the version of Office installed):

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

Use Edit -> New -> DWORD value to add a new item named AutoChartFontScaling and give it a value of 0.

This change affects only the charts that you create after making the registry change. Previously created charts are not affected. This registry entry simply controls the value of the Auto Scale check box in the Font tab of the Format Chart Area dialog box.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.