Reverse x-axis data

Question

Level 1

37 points

Reverse x-axis data

Hello,

I have an X-Y scatter plot. The x-axis goes from 0 on the left to 9 on the right. I'd like to plot it so that it goes from 9 on the left to 0 on the right. Does anyone know how to quickly flip the axis?

13" Macbook Pro, Mac OS X (10.5.8)

Posted on Feb 27, 2010 8:44 PM

Reply

Answer 1

Badunit

Level 7

30,948 points

Feb 28, 2010 12:07 PM in response to roberto

It is not a built in capability but there is a workaround. Create a new column that has the negative of your X values. Plot that column and your Y values. This will create the look of the chart you want. To remove the negative signs on the X axis numbers do the following:

1) Select the chart
2) Go to the Axis tab of the Chart Inspector
3) Choose a custom format for the X axis labels
4) In the format pane, click on the + to create a format for "if less than zero"
5) The default format might be all you need. Or maybe you want to drag the decimal places format to the end of it.
6) Click OK

Reply

Answer 2

roberto Author

Level 1

37 points

Mar 1, 2010 8:25 AM in response to Badunit

Thanks Bad...

This works. Another workaround I came up with is to sort the x data from largest to smallest (descending). With the y -data in the adjacent column, the sort function took it along for the ride. So this also gives me the look I wanted.

Reply