Forum Discussion

MikeA1335's avatar
MikeA1335
Copper Contributor
Aug 25, 2022
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 chart menu is active with a new file. What should I do to make the insert chart menu active?

  • 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.

7 Replies

  • 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.
    • MikeA1335's avatar
      MikeA1335
      Copper Contributor
      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.
      • JimGMac's avatar
        JimGMac
        MVP
        Check the Review tab of the Ribbon and click Protect Sheet and see if any restrictions have been turned on.

Resources