View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Reverse y-axis, with maximum number at x-axis

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.





"Elise" wrote:

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.
.