Hi Calvin C,
Thank you for reaching out to the Microsoft Community. My name is Somidotun and I'm happy to help.
Detailed steps to solve your issue: https://techcommunity.microsoft.com/t5/excel/suddenly-don-t-have-access-to-charts-grayed-out/m-p/1478471
If you still require assistance come back for further analysis
Yours Truly, Somidotun