Turn off Excel’s auto font scaling option

Have you ever tried to make your Excel chart larger by
dragging the corner sizing handle, only to find that the font size of the
title, legend, and the X/Y axis labels have changed?

By default, when you resize a chart, Excel adjusts the text
size accordingly. When you make the chart larger, the font size becomes larger;
when you make the chart smaller, the font size becomes smaller. But sometimes
you may want to make the chart larger without changing the font size. In that
case, you don’t have to resize the text back to the original; simply turn
off the auto font scale option. Follow these steps:

1. Right-click a blank area of the chart.
2. Select Format Chart Area.
3. In the Font tab, clear the Auto Scale check box, and
   click OK.

Now when you resize the chart, the font size will not change.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.