How to Fix Excel Crashing When Creating Custom Combination Charts
Question details
The user needs to resolve an issue where Excel crashes or becomes unresponsive when trying to create complex 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.
Make sure to save your current workbook to avoid losing any data before modifying the application settings and restarting the software.
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.
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.
In the Excel Options dialog box that appears, click on the 'Advanced' tab in the left-hand navigation pane.
Scroll down the list of options until you find the 'Display' section. Check the box labeled 'Disable hardware graphics acceleration'.
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.

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.

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.




