Fix Charts and Buttons Disappearing in Excel for Mac
Question details
Users experience disappearing visual objects like charts, buttons, and text boxes after switching between worksheets.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Navigating between different worksheets in an Excel workbook containing embedded visual elements.
- Observed behavior
- Charts, buttons, graphs, and text boxes become invisible upon returning to a sheet, but reappear when zooming in/out or resizing the application window.
Since this is a known interface rendering bug in certain versions of Excel for Mac, ensure you have saved your current workbook before attempting to resize or refresh your display to prevent accidental data loss.
Force Screen Render by Zooming or Resizing
Because this is a graphical rendering issue, forcing the application window to redraw its elements will temporarily bring back the missing objects.
This workaround immediately restores visibility to your charts and buttons without needing to restart the application.
Click the worksheet tab at the bottom of your screen where the charts or buttons have become invisible.
Use the zoom slider at the bottom right corner of the Excel window, or press 'Command' and scroll your mouse wheel to slightly zoom in or out.
Alternatively, click and drag the edge or corner of the Excel window to resize it, which forces the interface to refresh and display the missing graphical items.
Update Excel and Submit Feedback to Microsoft
This is a known issue reproduced in version 16.67 and reported to Microsoft. Keep your software updated to receive the official patch.
Try WPS Office to Avoid Mac Rendering Issues
Since the disappearing charts issue is a known rendering bug in Microsoft Excel for Mac, you can bypass it entirely by opening your spreadsheets in WPS Office. It provides a highly compatible, stable, and completely free alternative for Mac users.
- 1. Download and Install WPS Office: Get the free WPS Office for Mac installer from the official website and complete the installation.
- 2. Open your Excel file: Launch WPS Spreadsheet and click 'Open' to browse for your existing .xlsx workbook.
- 3. View and edit without rendering bugs: Navigate between sheets smoothly, as WPS Office handles objects and charts with stable rendering on macOS.
Frequently Asked Questions
Why do my charts disappear when I switch tabs in Excel for Mac?
This is a known software rendering bug in certain versions of Excel for Mac (such as version 16.67). The application occasionally fails to properly redraw visual objects like charts, buttons, and text boxes when the worksheet becomes active again.
Will my data be lost if the charts become invisible?
No, your underlying data and the charts themselves are perfectly safe. They are simply invisible due to a graphical interface glitch. Forcing a screen refresh by zooming or resizing the window will make them reappear.
Has Microsoft fixed this disappearing objects issue yet?
Microsoft has been notified of this bug and it was reproduced heavily around version 16.67. It is highly recommended to regularly check for updates via 'Help' > 'Check for Updates' to install the permanent patch once it is released.
Are there any permanent fixes other than updating?
While waiting for an official Microsoft update, the only permanent workaround is using a highly compatible alternative spreadsheet application like WPS Office, which natively supports .xlsx formats without these specific Mac rendering bugs.
