98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pie chart
Pie chart
Resolved · Low Priority · Version 2003
Kerry has attended:
Excel Intermediate course
Pie chart
how do you change the colour of a pie chart if it is locked.
RE: pie chart
Hi Kerry
Thank you for your question and welcome to the forum.
I assume when you say 'locked' you mean that you are not able to edit the chart in any way?
If so this may be because protection is applied to the worksheet. You can try removing this by going to Tools - Protection and see if you can select the Unprotect Sheet option - if so, this means that protection has been applied.
If you then select this option, you may be asked for a password. If you aren't then the protection is removed straight away and you can make changes. If there is a password, then there's not much you can do about that unless the person who put it on tells you what it is or uses it to remove the protection for you.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display Functions on WorksheetsFunctions in Excel can be difficult to recall their format/syntax |