Chart & Visualization Issues

How to Restore Missing Charts in an Excel Worksheet

Guest Writer Sep 28, 2026 869 views

Question details

The user needs to recover disappeared charts in an Excel worksheet and re-enable the grayed-out Insert Chart commands.

How to Restore Missing Charts in an Excel Worksheet

Product: Microsoft Excel
Device & OS: Mac
Scenario: Attempting to view existing charts or insert new ones in a worksheet where the data is fully visible.
Observed behavior: All existing charts are hidden from the worksheet, and the options to insert new charts are grayed out and cannot be clicked.

Before you start

Before troubleshooting, ensure you are not actively editing a specific cell (cursor flashing inside), as this temporarily disables all chart insertion tools in the ribbon.

Solution 1Recommended

Unhide Objects using Keyboard Shortcuts

The quickest way to restore missing charts is to toggle the object visibility setting using a simple keyboard shortcut.

Excel has a built-in feature to hide all objects, including charts, shapes, and images. When this is accidentally triggered, existing charts vanish and new ones cannot be inserted.

Press the unhide shortcut

On your Mac keyboard, press the combination Command+6.

Verify chart visibility

Check your worksheet to see if the missing charts have reappeared and the 'Insert Chart' commands are active again.

Windows Alternative: If you are using a Windows PC, the equivalent keyboard shortcut to toggle object visibility is Ctrl+6.

Solution 2

Modify Object Display Settings Manually

If the keyboard shortcut does not resolve the issue, you can manually verify and adjust the object display settings in Excel's advanced preferences.

WPS Spreadsheet Solution

Seamlessly View and Create Charts in WPS Office

If you frequently struggle with unexpected hidden settings and grayed-out menus in Excel, try switching to WPS Office. WPS Spreadsheet offers an intuitive interface where creating, viewing, and managing charts is straightforward and completely free.

1. Download and Install WPS Office: Download WPS Office for free from the official website and install it on your Mac or Windows PC.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open the Excel file that contains your data and missing charts.
3. Manage Your Charts: Your existing charts will be displayed automatically. To add new visual elements, simply navigate to the 'Insert' tab and click 'Chart'.

100% compatible with Microsoft Excel (.xlsx, .xls) formatsIntuitive chart creation and visualization tools with no hidden barriersLightweight software that opens large datasets instantlyCompletely free alternative to expensive office suites

microsoft office alternative - wps office

Frequently Asked Questions

Why are my Insert Chart commands grayed out in Excel?

This commonly happens if you are actively editing a cell, if the worksheet is protected, or if the 'Hide Objects' setting has been toggled on by accident.

Will my data be lost if the charts disappear?

No, your data is completely safe. The charts are merely hidden from view visually. Once you press Command+6 (Mac) or Ctrl+6 (Windows) to unhide objects, they will return exactly as they were.

Does this shortcut hide images and shapes as well?

Yes, the Command+6 or Ctrl+6 shortcut toggles the visibility of all graphical objects in the workbook, including charts, images, shapes, and smart art.

Can I view my complex Excel charts in WPS Office?

Absolutely. WPS Office is highly compatible with Microsoft Excel formats and seamlessly displays your existing charts, data, and formulas without requiring complicated settings adjustments.

Excel & Data Problems