'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Chart Option Grayed Out on Mac
Question details
The user is unable to insert a chart in a specific Excel workbook on Mac because the chart options in the menu are grayed out and disabled.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Attempting to insert a chart into an existing spreadsheet data set.
- Observed behavior
- The chart command is disabled (grayed out) in the affected workbook, but functions normally when opening a brand-new workbook.
Ensure your Microsoft Excel for Mac is updated to the latest version and verify that you have full editing permissions for the affected workbook.
Change Object Display Settings to Show All
Excel's View preferences may be configured to hide all objects, which inherently disables the ability to insert new charts or shapes into the workbook.
This setting is workbook-specific, which explains why you can insert charts in a new workbook but not in the affected one. Adjusting the display settings will restore the functionality.
With the affected workbook active, click on 'Excel' in the top Mac menu bar and select 'Preferences'.
In the Preferences window, locate and click on the 'View' icon.
Under the 'For Objects, show' section, change the selection from 'Nothing' to 'All'.
Close the Preferences window. Close and reopen the workbook, then try inserting the chart again.
Check and Remove Worksheet Protection
If a worksheet is protected by the author, structural changes—including inserting charts—will be restricted and grayed out.
Create Beautiful Charts on Mac with WPS Office
Avoid complex Excel settings and randomly grayed-out menus by switching to WPS Office. It is a completely free, highly compatible alternative that makes data visualization on Mac incredibly simple and intuitive.
- 1. Download and Install: Download WPS Office for Mac from the official website and complete the quick installation.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx workbook directly.
- 3. Insert Your Chart: Select your data, navigate to the 'Insert' tab, and choose your preferred chart type to instantly visualize your data.
Frequently Asked Questions
Why is the chart option grayed out in only one specific workbook?
This behavior indicates a workbook-specific setting rather than an application error. It usually happens because the object display settings are set to 'Nothing' for that particular file, or the worksheet has been individually password-protected against edits.
Does shared workbook mode disable the chart option on Mac?
Yes, using the legacy 'Shared Workbook' feature in Excel restricts many advanced tools, including inserting charts, pictures, and hyperlinks. To insert a chart, you must temporarily turn off legacy sharing.
What should I do if the 'Unprotect Sheet' option is also grayed out?
If 'Unprotect Sheet' is disabled, the entire workbook structure might be protected, or the file may be opened in Read-Only mode. Check if the file is marked as 'Final' or if it is saved in a restricted or read-only network folder.
