If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reverse y-axis, with maximum number at x-axis
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. |
#2
|
|||
|
|||
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. . |
Thread Tools | |
Display Modes | |
|
|