Microsoft Excel Question

blipblop

Senior member
Jun 23, 2004
639
0
76
I have some data that is in quadrant 3... so the values are negative(X and Y). Is there anyway for me to just move it to quadrant 1? In order for me to do this.. I need the Y-axis to decrease going up.

IE. "0, -1, -2, -3, -4, etc" This might be a bit confusing, but if someone can PM or contact me, I have the data I can send them.

Thanks
 

edcarman

Member
May 23, 2005
172
0
71
If you're creating a scatter (X-Y) plot, make the graph and then right-click on the axis.
Select 'Format axis...' and go to the 'Scale' tab.
At the bottom is a check bxo for 'Values in reverse order'.
This works on both x and y axes.