View Single Post
 
Old 12-05-2014, 09:47 AM
chocochris chocochris is offline Windows 8 Office 2007
Novice
 
Join Date: Dec 2014
Location: Indonesia
Posts: 1
chocochris is on a distinguished road
Default How to make a ranking graph in Excel?

Hello guys, I really need help ASAP for my thesis.
I would like to make a graph of ranking using Excel, but the problem I face is this :
-For example, in the X axis, I have a date data, (eq: 1st Jan, 2nd Jan, 3rd Jan, etc), and on the Y axis, I have a products quantity, so if my product's quantity is increasing (eq : from 10 to 20), then the graph will get higher, as the number get higher or increasing
-But, If i want to make a ranking graph, the higher the number is, then the graph should be lower, but the lower the number is, the graph should be higher (eq: u got 1st rank, then become 10th rank, the graph should go down, as the number increase, or u got 10th rank, then u got 1st rank, then the graph should rise up, as the number decrease)

Can anyone help me to solve this? I really need your help for my thesis

Thanks
Reply With Quote