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

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.07 secs.