Forum Discussion
Solved
Can't edit charts - all options greyed out
Hi - I've recently been upgraded to Office 365. I've got a regular reporting spreadsheet, with charts that need updating. However, I can't edit any of the charts! I can't right click anywhere on th...
- Well I managed to find a solution - I copied all the tabs from my original workbook into a new workbook, and I could then edit the charts. Still don't know what caused the original problem, but putting up this solution for anyone who faces the same issue in future
Please read the information in this link (at the end) and include this information in your request.
In this way you could get a solution proposal much faster and more precisely and it saves the helpers time, with which they can answer more questions. Win-win for everyone.
Link: Welcome to your Excel discussion space!
Thank you for your understanding and patience
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
Thanks NikolinoDE
I'm running PC Windows 10, Version 1909 (OS Build 18363.1679)
I'm using 'Microsoft 365 Apps for Enterprise' Version 2009 (Build 13231.20390 Click-to-Run)
Cut down file is attached
I want to update the charts on sheet 'Weekly giving semi-annual' and 'Income comparisons quarterly' to extend the series show.
However, I can't edit any of the charts! I can't right click anywhere on the sheets containing the charts, and all the options on the 'Chart Design' and 'Format' ribbon tabs are greyed out.
- As far as I could understand the problem lies in the combination with Power Querie. Unfortunately, my knowledge is very limited, I am looking for it, but the expertise of the specialists is required here.
Thank you for your understanding and patience
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)