Chart & Visualization Issues

How to Fix Excel Chart Elements and Scatterplot Formatting Not Working

Nimra Malik Sep 25, 2026 869 views

Question details

Chart formatting commands, such as Change Colors and Format Data Series, fail to update scatterplots or display dropdown menus in Excel.

How to Fix Excel Chart Elements and Scatterplot Formatting Not Working

Product: Microsoft 365 Excel
Device & OS: not provided
Scenario: Attempting to modify the colors and filled styles of a scatterplot chart after a recent Office software upgrade.
Observed behavior: The chart does not reflect the selected format changes, menus remain unresponsive, and standard Office repair tools fail to detect the installed application.

Before you start

Before making changes to your Office installation, create a new blank workbook and insert a simple scatterplot to verify if the issue is specific to a single file or affects the entire Excel application.

Solution 1Recommended

Roll Back to a Previous Office Build

Since the formatting issue often begins after a recent Office update, reverting to a stable earlier build can resolve the unresponsiveness in the chart menus.

Microsoft Office updates can sometimes introduce bugs affecting chart rendering and UI menus. Using the Command Prompt to revert to a known working version bypasses the glitch until Microsoft releases a permanent patch.

Open Command Prompt as Administrator

Click the Windows Start menu, type 'cmd', right-click on 'Command Prompt', and select 'Run as administrator'.

Navigate to the ClickToRun Folder

In the Command Prompt window, type 'cd %programfiles%\Common Files\microsoft shared\ClickToRun' and press Enter.

Execute the Rollback Command

Type 'OfficeC2RClient.exe /update user updatetoversion=16.0.17531.20120' and press Enter to start downloading and applying the previous stable version of Office.

Disable Automatic Updates Temporarily

Open Excel, navigate to File > Account, click on 'Update Options', and select 'Disable Updates' to prevent the buggy version from reinstalling automatically.

Check Chart Formatting: After the rollback is complete, open your workbook to verify that the 'Change Colors' and 'Format Data Series' menus are functional again.

Solution 2

Run Excel in Safe Mode

Safe mode launches Excel without third-party add-ins, helping you identify if an external plugin is causing the chart menus to freeze.

Solution 3

Use Microsoft Support and Recovery Assistant (SaRA)

When standard repair tools fail to detect your Office installation, the SaRA tool can help diagnose the issue and perform a clean reinstallation.

Free Microsoft Office alternative

Try WPS Office for Flawless Data Visualization

If Microsoft Excel continues to experience update bugs that break chart elements and formatting menus, consider switching to WPS Office. It provides a highly compatible and stable environment for all your spreadsheet and data visualization needs without heavy background updates disrupting your workflow.

1. Download and Install WPS Office: Visit the official WPS website, download the free installer, and complete the quick installation process.
2. Open Your Excel Files: Launch WPS Spreadsheet and open your existing .xlsx workbook. Your scatterplots and data will load seamlessly.
3. Format Charts Easily: Click on any chart to access the intuitive chart design tools and format your scatterplot colors and styles instantly.

Free to use with a familiar, intuitive spreadsheet interfaceFully compatible with Microsoft Excel (.xlsx) files and advanced chartsLightweight architecture that avoids heavy, buggy system updatesEasily create, customize, and format scatterplots without menu freezes

microsoft office alternative - wps office

Frequently Asked Questions

Why is the 'Change Colors' menu unresponsive in Excel charts?

This unresponsiveness is typically caused by a glitch introduced in a recent Office software update, which corrupts the UI rendering for chart design elements. Rolling back to a previous Office version or performing a clean reinstall usually resolves the issue.

How do I fix scatterplot symbols not filling with color?

If the 'Format Data Series' pane doesn't apply changes (like filling symbols), test the file in a new workbook to rule out file corruption. You can also run Excel in Safe Mode to ensure third-party add-ins aren't interfering with the charting engine.

What should I do if the standard Office Repair doesn't detect my apps?

When standard Windows settings fail to detect Office, it points to corrupted registry keys. You should use the official Microsoft Support and Recovery Assistant (SaRA) tool, which is specifically designed to deeply scan, detect, and cleanly uninstall broken Office installations.

Excel & Data Problems