Office for Mac Issues

How to Fix Excel for Mac Chart Options Greyed Out

Camila Milosovich Oct 8, 2026 871 views

Question details

The user is unable to create or edit charts in Excel for Mac because the chart options and tools are greyed out and unavailable.

How to Fix Excel for Mac Chart Options Greyed Out

Product: Microsoft Excel
Device & OS: macOS
Scenario: Attempting to insert or format a chart in an existing Excel workbook on a Mac device.
Observed behavior: The chart tools and options in the ribbon are entirely greyed out, preventing the user from interacting with or editing embedded charts, although they might work in a new blank workbook.

Before you start

Before proceeding, ensure that you have the latest updates installed for both Microsoft Excel and your macOS. It is also recommended to save a copy of your current workbook to prevent accidental data loss during troubleshooting.

Solution 1Recommended

Enable the Show Objects Setting

Use this solution if chart tools suddenly become unavailable, as the object visibility setting is often toggled off accidentally.

In Excel, charts and graphs are treated as embedded objects. If the application is set to hide objects, all chart-related options will be greyed out in the ribbon. Re-enabling this setting restores normal functionality.

Navigate to the View Menu

Open your Excel workbook and click on the 'View' tab located in the top ribbon.

Enable Show Objects

Look for the 'Show Objects' option in the View menu and ensure it is checked or enabled.

Use the Keyboard Shortcut

Alternatively, press the 'Ctrl+6' shortcut on your keyboard to instantly toggle the visibility of objects and charts back on.

Shortcut Tip: Pressing Ctrl+6 is a quick toggle switch. If you ever find your charts suddenly missing or uneditable, pressing this shortcut is the fastest way to check if object visibility was accidentally disabled.

Solution 2

Troubleshoot Workbook-Specific Corruption

Apply this fix if your chart tools work perfectly in a brand new workbook but remain greyed out in your current file.

Free Microsoft Office alternative

Use WPS Office to Edit Excel Charts Without Errors

If Excel for Mac continues to freeze or grey out your chart options, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for Mac users to open, edit, and visualize spreadsheet data seamlessly.

1. Download WPS Office: Visit the WPS Office website and download the Mac version of the software for free.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open the exact file where the charts were previously greyed out.
3. Edit Your Charts: Navigate to the Insert tab to add, customize, and edit your charts with fully functioning data visualization tools.

Fully compatible with Microsoft Excel (.xlsx and .xls) formatsRobust and easy-to-use chart creation tools without the annoying bugsLightweight software that runs smoothly on all recent macOS versionsCompletely free to use with a familiar interface for quick migration

microsoft office alternative - wps office

Frequently Asked Questions

Why did my chart tools suddenly grey out in Excel for Mac?

This commonly occurs when the 'Show Objects' setting is accidentally toggled off. When objects are hidden, Excel disables all tools related to embedded elements like charts and images. You can usually fix this by pressing Ctrl+6.

Can updating macOS cause Excel charts to stop working?

Yes, major operating system updates (like macOS Sonoma) can occasionally introduce compatibility glitches with Microsoft Office. Ensuring you have installed the latest patches for both macOS and Excel typically resolves these temporary bugs.

How do I know if my Excel workbook is corrupted?

The easiest way to check for workbook corruption is to create a new, blank spreadsheet. If chart tools work perfectly in the new file but are greyed out in your old one, the original file is likely experiencing document-specific corruption.

Office App Problems