Hello,

I have a problem with graph data labels in a protected sheet.

I have several pie charts in the sheet and for small categories the data labels are on top of one another. I would like to be able to protect the sheet to avoid altering the formulae and format of certain cells but at the same time I wan't to be able to change data labels to make them readable.


Any ideas? Instead of protecting the Excel sheet and unprotecting the cells that I wan't to be able to change, is there a way of protecting only the cells I don't want users to change?



I hope I have made myself clear.
Thank you in advance.
Kind regards,

gjrr4x1