Forum Discussion
Solved
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 creat...
The trick is to uncheck the box, see screen shots.
Click Share WorkbookUncheck the box and OK
this worked---Go to File > Options > Advanced. Under "Display options for this workbook," ensure "For objects, show:" is set to All.