Forum Discussion
Can't create chart, option grayed out
Using Excel Home and Business 2013 Version 15.0.5023.1000. Just updated it now.
I had this same problem with an old spreadsheet, where suddenly I could no longer add new data to the chart. So created today a new sheet with new data, just 40 lines and 5 columns. I want to use data from 3 columns for chart as I had in old sheet.
When I still couldn't insert chart, tried Help. The most relevant seeming thing had info only in video, only about Power View ( which apparently my version doesn't support) and the dumb video, if you paused it or tried to go back 10 seconds, the #@@%^ thing wouldn't restart unless I went back to beginning of video. #FAIL on on so many levels.
So I looked on this forum, and based on other threads, updated my version of Excel, checked that everything that's supposed to display is displayed (see attached), and still problem exists.
I'm not a power user but I've always been able to use my data to create charts no problem. Any suggestions on what might be the problem now? TIA.
The trick is to uncheck the box, see screen shots.
Click Share WorkbookUncheck the box and OK
14 Replies
- Is the sheet protected by any chance?
JKPieterse wrote:
Is the sheet protected by any chance?no it is unprotected
- IN Excel 2016, the share workbook button has been removed from the ribbon. You can add it to your Quick Access Toolbar temporarily, you may find the button if you select "All commands" from the dropdown.
No, it is not protected. Thanks.
If you open your old workbook and Save As it into new one (.xlsx) will it be the same?
