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.