Chart & Visualization Issues

Set Arial as the Default Font for Excel Charts

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

Set Arial as the default font for Excel chart elements and apply the setting to existing workbooks where possible.

Set Arial as the Default Font for Excel Charts
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants chart titles, axes, legends, and other chart text to use Arial in new and existing workbooks.
Observed behavior
Changing the worksheet default font does not necessarily change chart text, which can follow the workbook theme or retain manually applied fonts.
Before you start

Open a workbook containing a chart and check whether its chart text follows the theme or has an explicitly selected font. Changing theme fonts affects theme-linked text throughout the workbook, not just charts.

Solution 1Recommended

Set Arial in the workbook's theme fonts

Use a custom font theme to apply Arial to chart text that follows the workbook theme.

1
Open theme fonts

Open the workbook in Excel, then select Page Layout > Fonts in the Themes group.

2
Create an Arial font theme

Choose Customize Fonts or Create New Theme Fonts. Set both the heading font and body font to Arial, enter a name, and select Save.

3
Check the charts

Select chart titles, axes, and legends to verify their fonts. Theme-linked text should use Arial; explicitly formatted text may need to be changed separately.

4
Save the workbook

Select File > Save to keep the theme setting in the workbook. Repeat the process for other existing workbooks as needed.

Existing font overrides: A theme change does not necessarily replace fonts manually applied to chart elements. Select an affected element and choose Arial on the Home tab, or restore a theme font where available.
Free Microsoft Office alternative

Work with spreadsheets and charts in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for a smoother move between applications. It does not change chart font settings inside Microsoft Excel.

Create and edit spreadsheet charts in WPS SpreadsheetsOpen and save Excel-compatible XLSX workbooksUse a familiar interface for common spreadsheet tasksWork with a lightweight, free Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel charts still use Calibri after I change the worksheet font?

Chart text can follow the workbook's theme fonts rather than the worksheet default font. Set the heading and body fonts to Arial under Page Layout > Fonts.

Will changing the theme update every existing chart?

It updates chart text that follows the theme, but manually applied fonts may remain. Select affected chart elements and choose Arial on the Home tab if needed.

Can I apply the Arial theme to hundreds of existing workbooks at once?

Changing the theme in one workbook does not automatically change the others. For a large library, VBA or another automation process may be appropriate, but charts with manual font overrides may still require additional handling.

How can I reuse the Arial setting in new workbooks?

Save a workbook with the Arial theme through File > Save As as an Excel Template (*.xltx). Then choose it from the Personal or Custom templates list under File > New.