Reverse y-axis, with maximum number at x-axis

E

Elise

I would like to find out if it is possible to "reverse" the y-axis,
where zero is at the top of the axis, and the highest positive number
is in the bottom left corner where the x-axis intersects. I have a
line graph showing rankings, where a lower number is considered
better. I would like the lines to rise as the rankings get lower. Is
there any simple setting to have this occur?

Thank you for any suggestions.
 
T

trip_to_tokyo

In EXCEL 2007 try this:-

1. Click in the Y axis (this will place a box around it to highlight it).

2. ChartTools / Format / Current Selection group / Format Selection / Format
Axis pop up window should launch with Axis Options, on the left, highlighted
in orange.

3. On the right hand side select:-

Values in reverse order.

If my comments have helped please hit Yes.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top