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