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

pie charts

ResolvedVersion 2010

Michael has attended:
PowerPoint Introduction course
PowerPoint Introduction course

Pie charts

How do I manually override figures if Excel rounds to 100%?

RE: Pie charts

Hello Michael,

Hope you enjoyed your Microsoft PowerPoint Introduction course with Best STL.

Thank you for your question regarding adjusting the percentage to not round to 100%

I presume you are referring to the labels. If so, you can modify the settings as follows:

1) In the Layout ribbon select the Data Labels button and choose the last option 'More Data Label options'.
2) Select the Number option on the left side
3) Choose the Percentage option and then click Close

The percentages should now appear exactly as they should without rounding.



I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Fri 31 May 2013: Automatically marked as resolved.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

PowerPoint tip:

To copy an object on your page

To copy an object on your page quickly and easily instead of using cut & paste, try this instead.

Select the object you want to copy by clicking on it.

Hold down the "CTRL" key on the keyboard.

Click (with the left mouse button) and drag the object to the new position. Simple & quick.

Now try it again but press the "Shift" key at the same time as the CTRL key, this will keep the objects aligned. Great for making diagrams etc.

View all PowerPoint hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.53 secs.