Help finding Function to put double datas into percentages

Hi there!

I'm wondering what function I should be using to transform numbers I already have into percentages (I have been strictly told that it is possible to do this USING ONE SINGLE FUNCTION).

Here's my initial data: http://puu.sh/mWAdt/9655d0a1e6.png

Here's what it should look like in percentages: http://puu.sh/mWAhT/eec32beb0f.png

I'm not asking how to change my values in percentages once I have them, I'm asking how to actually transform them in percentages by using one single function. I could easily do them individually by dividing my initial data by the total amount but I've been told there's a way to do it all in with one function. I'm sure it has to do with using absolute reference ($X$X), but if I try to put a column, my initial value disappears and therefore I can't make the calculation.

Any help would be greatly appreciated. =)

Something like this?

Just

=A1/B1 and FORMAT cell as percentage

I like this "I have been told..."

Can't the person who told you this actually show you how, or is it a teacher at school who has said this to you?

Pete

YES! Exactly! Of course I never thought of copying a first graph and using those points as reference. Thank you!

And what if I wanted to compare the two datas with eachother? Either like this: http://puu.sh/mWBeZ/3708bf6013.png or the other way around like this: http://puu.sh/mWBfD/4ef7f7652b.png ?

Eh, you deal with what you have I guess. Pretty much self-learning when it comes to university teachers who have >150 students