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 c...
excel
  • MikeA1335's avatar
    MikeA1335
    Aug 26, 2022
    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.
MikeA1335's avatar
MikeA1335
Copper Contributor
Aug 25, 2022
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
Aug 25, 2022
Check the Review tab of the Ribbon and click Protect Sheet and see if any restrictions have been turned on.
  • MikeA1335's avatar
    MikeA1335
    Copper Contributor
    Aug 25, 2022
    2 of the boxes are checked, "select locked cells" and "select unlocked cells". All other items are unchecked.
    • JimGMac's avatar
      JimGMac
      MVP
      Aug 26, 2022
      Unfortunately, Windows Excel has a couple more options. If you add a new worksheet to the workbook, can you use the chart tools?
      • MikeA1335's avatar
        MikeA1335
        Copper Contributor
        Aug 26, 2022
        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.

Resources