Forum Discussion
Solved
Excel for Mac insert Chart menu
I have an older excel file originally created in Windows. I am now using axel for Mac on a MacBook. The Insert Chart menu is greyed out. Problem appears to be with the file parameters as the insert c...
- No, the chart tools don't work on a new worksheet. I can copy a worksheet into a new file and the chart tools will work.
The old workbook may have been saved in a binary file format that does not support Excel's current chart tools. To update the workbook, in Excel use File > Save As and change the format to Microsoft Excel Binary workbook (.xlsb). Then you should be able to use the chart tools.
The file was originally saved in .xlsx format on a Windows version, I saved as .xlsb on my MacBook and I still couldn't access the chart tools.
- Check the Review tab of the Ribbon and click Protect Sheet and see if any restrictions have been turned on.