Fix Excel Crashes When Opening the Chart Design Tab
Question details
The user needs to stop Excel from crashing when opening the Chart Design tab for a formula-driven line chart.

- 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.
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.
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.
Close Excel. Press Windows+R, enter excel /safe, and select OK.
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.
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.

Repair the Microsoft Office installation
Use Office repair if the crash persists or disabling add-ins does not resolve it.
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.

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.




