How to make a ranking graph in Excel?

[chocochris]

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

[Tuph]

It would help if you attach a copy of your workbook. Remember to remove/replace any sensitive data before uploading.