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