How do I get a value of ONE at the top of my Y-axis?

[clickadai]

Hello

I'm creating a chart which shows league rankings, where one is the best (and for this particular chart 25 is the worst).

I'm plotting the league rank against the date that rank was obtained.

I want my y-axis to have a value of 25 at the bottom (where it meets the x-axis) and a value of 1 at the top.

I've played around in excel and the best I can get is:

0 at the top of my y-axis
25 at the bottom of my y-axis
x-axis meets y-axis at 0 so is at the top of the chart when i need it at the bottom.
​

Any suggestions?

Thanks

Mark

 

[clickadai]

OK. I've figured this out, but it has left me with another problem.

Now my x-axis labels (SEP-09; OCT-09; etc...) are above the x-axis, how do I get them below the axis?

Thanks

 

[clickadai]

Problem Solved.