Office Apps Crashing

Fix Excel Crashes When Opening the Chart Design Tab

Bushra ParveenBushra Parveen Nov 22, 2026 869 views

Question details

The user needs to stop Excel from crashing when opening the Chart Design tab for a formula-driven line chart.

Fix Excel Crashes When Opening the Chart Design Tab
Product
Microsoft Excel
Device & OS
not provided
Scenario
A formula-driven line chart is selected, and the user opens the Chart Design tab. Some cells in the chart range return empty strings.
Observed behavior
Excel crashes when the Chart Design tab is opened, although Chart Filters and Chart Elements work normally.
Before you start

Note whether the crash occurs with other charts or only the affected line chart. The Safe Mode and Office repair instructions below apply to Excel on Windows.

Solution 1Recommended

Test Excel add-ins in Safe Mode

Use Safe Mode to check whether an add-in is involved, then disable add-ins one at a time.

1
Start Excel in Safe Mode

Close Excel. Press Windows+R, enter excel /safe, and select OK.

2
Reproduce the crash

Open the affected workbook, select the line chart, and click the Chart Design tab. If Excel does not crash, an add-in may be involved.

3
Disable add-ins individually

Restart Excel normally and go to File > Options > Add-ins. In the Manage list, select COM Add-ins and click Go. Clear one add-in, click OK, and test the Chart Design tab again. Repeat for each add-in; also check Excel Add-ins in the Manage list.

Test Excel add-ins in Safe Mode
If Excel still crashes: A crash in Safe Mode means an add-in is less likely to be the cause. Try repairing Office.
Free Microsoft Office alternative

Work with Line Charts in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface and support for Excel formats, making it easier to move existing spreadsheets into another app. It does not repair the Excel crash.

Open and work with Excel XLSX and XLS filesCreate and edit line charts in WPS SpreadsheetUse a familiar spreadsheet interfaceMove existing Office files into a lightweight application
microsoft office alternative - wps office

Frequently Asked Questions

How do I open Excel in Safe Mode?

On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Then open the workbook and test the Chart Design tab.

How can I tell which add-in is causing the crash?

If the crash disappears in Safe Mode, restart Excel normally and go to File > Options > Add-ins. Use the Manage list and Go button to disable one add-in at a time, testing the chart after each change.

Should I use Quick Repair or Online Repair?

Start with Quick Repair through Windows Settings > Apps > Installed apps > Microsoft Office or Microsoft 365 > Modify. If the crash continues, return to Modify and try Online Repair.

Do formulas returning empty strings cause the crash?

The chart range contains cells returning empty strings, but that alone does not establish the cause. Test Excel in Safe Mode and check add-ins before changing the formulas.