Forum Discussion
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
What did you do to fix the file? That file is just a cut down of a much larger file that I use
I uploaded file into Google Sheets and immediately (i.e. without any changes) download it from here as Excel file.
- Ah - that doesn't work with my larger file as Google Sheets screws up all sorts of other things. I need a solution to the underlying problem with the charts that I can fix in Excel