Unlock Excel Chart

[Nasser]

Hi,

In excel, I am using a chart. I want to be able to edit my chart when my sheet is protected. Now when the sheet is protected and i try to change the scale for example of my axis, it does not allow because my entiere sheet is protected. How do i unlock my chart for the user to edit?

Many thanks,
Nasser.

[HansV]

When you protect the sheet, you see a list of check boxes to specify what the user is allowed to do. Tick the check box "Edit objects".

x424.png

[Nasser]

Many thanks Hans
Regards,
Nasser