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

  • Thread starter Thread starter Elise
  • Start date Start date
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.
 
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.
 
Back
Top