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...
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 cell
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 cell
Thanks a lot, the above worked perfectly for me💜
Ditto for me! :-)
