Forum Discussion
Suddenly don't have access to charts (grayed out)
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
Awesome
Thanks a lot, the above worked perfectly for me💜
Ditto for me! :-)
I have tried and retried these steps to make charts available in the Excel Workbook I am using. It is not working. I tried toggling the All to Nothing and then back to All to see if that would help. Tried three times. Still no access to charts. Any suggestions?Abiola1
I noticed the entry above with Richard Weeks and Jalexy about Unprotecting and Protecting the sheet. I tried to unprotect the worksheet and it requires a password. I don't have the password.
paulabbottThat sounds like it's a protected sheet then. You'll need the password. The original author of the file will hopefully have it. Find the file and right click it, then go Properties > Details ... Authors will be one of the fields in there. You can also hopefully see who last saved the file... Hopefully you can track down who in your organisation to email and get a password. Good luck!
RichardWeeks Thank you for this comment and suggestion! When I realized it was protected, I decided to copy the portions i needed to a new excel document. That must have not carried with it the protection because I was able to modify as needed. Thank you for starting me on this solution with your comment!
- All of my graphs have disappeared and my settings are set to show all objects, any advice on getting them back?
You're awesome! This worked for me.
Next question is... how did it get turned off? Is there some obscure keyboard shortcut that does this, or maybe a recent update? I didn't even know this option existed, and there's no way I turned it off by going through the menus...
lowbar The same thing happened to me, which is what led me here. You were probably trying to do the same thing I was by pressing Ctrl + Y to redo, and accidently hit the shortcut, Ctrl + 6, instead.
khow105 this was the solution for me. I'm using Mac Excel, and File / Options, the first suggestion in this thread, doesn't appear available to the Mac UI.
I must have hit Ctrl 6 accidentally. For those not in the know, it apparently toggles a https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f (search for "ctrl+6"), which, if objects are hidden, then disables charting.
Who knew? I guess @khow105 did. Thanks for the post.
