pie chart

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pie chart

Pie chart

resolvedResolved · 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


 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.08 secs.