Chart & Visualization Issues

How to Fix Excel Crashing When Creating Custom Combination Charts

Steven ParkerSteven Parker Nov 4, 2026 868 views

Question details

The user needs to resolve an issue where Excel crashes or becomes unresponsive when trying to create complex custom combination charts.

How to Fix Excel Crashing When Creating Custom Combination Charts
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating a custom combination chart containing multiple scatter plots and a secondary axis, typically within a large workbook.
Observed behavior
Excel crashes or freezes, and the Change Chart Type dialog becomes completely unusable during the process.
Before you start

Make sure to save your current workbook to avoid losing any data before modifying the application settings and restarting the software.

Solution 1Recommended

Disable Graphics Hardware Acceleration in Excel

Turning off hardware acceleration forces Excel to use software rendering, which often prevents crashes caused by graphics driver conflicts during complex chart generation.

Graphics hardware acceleration allows Excel to use your computer's GPU to speed up the drawing of graphics and animations. However, in large workbooks with intricate charts (like multiple scatter plots on a secondary axis), this feature can cause the application to hang or crash due to compatibility issues with display drivers.

1
Open Excel Options

Launch Microsoft Excel, click on the 'File' tab located in the top-left corner of the ribbon, and select 'Options' at the very bottom of the menu pane.

2
Navigate to Advanced Settings

In the Excel Options dialog box that appears, click on the 'Advanced' tab in the left-hand navigation pane.

3
Disable Hardware Acceleration

Scroll down the list of options until you find the 'Display' section. Check the box labeled 'Disable hardware graphics acceleration'.

4
Apply and Restart

Click the 'OK' button to apply the changes. Fully close out of Microsoft Excel and restart the application before attempting to build your combination chart again.

Disable Graphics Hardware Acceleration in Excel
Hardware Acceleration Location Notice: In newer versions of Office 365, the 'Disable hardware graphics acceleration' option may have been removed from the Options menu. In such cases, the setting can sometimes be toggled via the Windows Registry or by updating your PC's dedicated graphics drivers.
Free Microsoft Office alternative

Create Complex Charts Smoothly with WPS Office

If Microsoft Excel continues to crash or lag when handling large workbooks and complex data visualizations, consider switching to WPS Office. It is a free, lightweight, and highly compatible alternative that effortlessly processes custom combination charts, multiple axes, and heavy datasets without frustrating performance drops.

Seamlessly build custom combination charts and secondary axes without application freezing.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight architecture ensures highly stable performance even with large, data-heavy workbooks.Familiar, intuitive user interface requires zero learning curve for Excel users.
QA img-9

Frequently Asked Questions

Why does Excel crash when using a secondary axis in charts?

Complex charts with multiple scatter plots and secondary axes require significant graphical processing. If there is a compatibility conflict between Excel's rendering engine and your system's graphics driver, the application will often freeze or crash.

Will disabling hardware acceleration affect Excel's overall performance?

Disabling it forces the CPU to handle graphics rendering instead of the GPU. While you might notice slightly less smooth visual animations, it drastically improves stability and prevents crashes when working with visually demanding charts.

What should I do if the 'Change Chart Type' dialog is still unresponsive?

If the dialog remains unresponsive after disabling hardware acceleration, try running Office's 'Online Repair' tool from the Windows Control Panel, or open Excel in Safe Mode to verify if a third-party COM add-in is causing the crash.