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

excel microsoft training - excel charts

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - Excel Charts

excel microsoft training - Excel Charts

ResolvedVersion Standard

Havva has attended:
Excel Intermediate course
Excel Advanced course

Excel Charts

Dealing with percentages in charts. Why are percentages x by 100.

RE: Excel Charts

Hi Havva,

Do you mean that every time you enter a number and set it as a percentage it comes out 100 times larger. For instance if you enter 10 and convert it to a percentage you end up with 1000%?

If so simply enter the value in to the cell as a decimal fraction. For example if you want 25% first type in 0.25 and then format as a percentage.

Regards

Stephen

 

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.

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.