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