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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

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
 
Upvote 0

Forum statistics

Threads
1,187,180
Messages
5,962,062
Members
438,579
Latest member
fishkeeper

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