Protect sheet and edit Objects

In Excel 2007 is there a way to protect a sheet and edit the data lables on a pie chart? I cannot seem to get this to work

---------- Post added at 12:24 PM ---------- Previous post was at 11:49 AM ----------

Just to add, I am able to delete the labels but cannot move them

Not sure if my first post went through... I think I am having the same issue. I need to keep a sheet protected but also need it to be flexible so that users can format the appearance of the charts on the page. Really, all I need is for the users to be able to move the pie chart labels.

As an fyi, I can edit the chart labels, edit the contents of the chart, but can't move them. I have the following exceptions enabled for the protections on my sheet: Alow Users to: select locked cells, select unlocked cells, format columns, edit objects, edit scenarios.

Thanks to anyone who can help!

Originally Posted by millsrya

Not sure if my first post went through... I think I am having the same issue. I need to keep a sheet protected but also need it to be flexible so that users can format the appearance of the charts on the page. Really, all I need is for the users to be able to move the pie chart labels.

As an fyi, I can edit the chart labels, edit the contents of the chart, but can't move them. I have the following exceptions enabled for the protections on my sheet: Alow Users to: select locked cells, select unlocked cells, format columns, edit objects, edit scenarios.

Thanks to anyone who can help!

I seem to be having the same problem as you

Hello millsrya, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.