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

clickadai

New Member
Joined
Mar 10, 2010
Messages
4
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
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

clickadai

New Member
Joined
Mar 10, 2010
Messages
4
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,194
Messages
5,768,778
Members
425,495
Latest member
Ragamacam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top