Excel’s charts include text in many places — the title, legend, axis labels, and data series labels, for instance. To change the default font for these text objects, you may approach the task by formatting each type of object individually. However, if you want to make the same font changes throughout your chart, you can do it all at once. Double-click on the chart area (the white area just within the border of the chart) to display the Format Chart Area dialog box. Then, select the font settings you want to use throughout your chart, and click OK.

Adapt for Excel 2007

In Excel 2007, you can quickly change your chart’s default font for every portion of the chart. Just select the chart and go to the Home tab. In the Font group, select a new font type from the Font dropdown list. The font in your entire chart changes to match the new font type.

Filed under: Microsoft Office Tutor