Forum Discussion
Suddenly don't have access to charts (grayed out)
I have owned MS Office (not 365) for a few years and I had been charting my financial data that I enter into an Excel spreadsheet each week. Now, suddenly, when I try to chart my data, the recommended chart icon is grayed out as is all the specific choices of charts. Pivot Tables icon seems to work. What happened and how do I fix it?
18 Replies
I am trying to make a graph of data in excel 360 V.2307 and it is grayed out. There are several questions asked about this issue, but all the answers I find are not matching the menu or selections of my version. I followed one person whitch stated go to Options then Advanced then Display Options then select a line about objects and click ALL. but I have not such choice. Graphs are a fundamental tool of spreadsheets. I find it problematic that the feature is greyed out on this tool. I tried adding a custom button to add graphing but that also does not work. WHY???
- The sheet might be protected. If you go to the 'Review' bar, then towards the right hand side of the options will either say "Protect Sheet" or "Unprotect Sheet". If it says "Unprotect Sheet", click that and unprotect it, then you cna use the chart options.
- Hello,
1. Click on File and click on Options.
2. On the left side click on “Advanced”.
3. Scroll down to the “Display options for this workbook:”.
4. Locate “For objects, show:”
5. Check “All”.
And click OK
That should bring back the objects including charts.
In addition, ensure that you're not typing anything inside a cellThank you so much, it solved my problem
Awesome
Thanks a lot, the above worked perfectly for me💜
Ditto for me! :-)
