Ask Your Question

chart option is greyed out in the insert menu

asked 2019-02-13 10:04:04 +0100

Dave-fr gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-13 10:17:16 +0100

Opaque gravatar image

updated 2019-02-13 11:15:26 +0100


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

edit flag offensive delete link more


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

Dave-fr gravatar imageDave-fr ( 2019-02-14 03:51:24 +0100 )edit

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

Opaque gravatar imageOpaque ( 2019-02-14 10:30:18 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-13 10:04:04 +0100

Seen: 26 times

Last updated: Feb 13