chart option is greyed out in the insert menu

i save the spreadsheet as excel 2007-2019 .xlsx and now the chart option in the insert menu is greyed out. How do I get it to work?

Hello

my very first idea - Is it possible that you opened your .xlsx in read-only mode? In that case “chart” in “insert” is not available, since it would mean a change / edit of the file, which would be impossible due to read-only. You did not specify you OS so I can only give the additional general advice to check the access permission of the file on the OS level (in case of Linux: permission u+w).

Thank you for your thoughts. I remembered that I had protected the spreadsheet and when I unprotected it the chart option became available. I am using Windows 10

Ok - if my hint is correct, please mark the question as aswered, so other user can find it as such. Thanks in advance.