How can I reverse the axis in Numbers '09? I need to be able to create charts similar to the below Excel screen shot. This is easily done in Excel by selecting the "Values in reverse order" checkbox. I want to get away from Microsoft products, but can not seem to discover the needed functionality in Apple products.
Numbers '09-OTHER, Mac OS X (10.7.3)
Using the Scatter Chart, the only chart that treats the x axis as a value axis, Numbers will graph values in any of the four quadrants.
But...
Numbers will always place the x and y axes at the minimum x or y value of the range of values to be graphed, whether the minimum is set by the user or determined automatically from the data. The axes on the above graph are shapes, lines inserted by the Shapes button's menu, and placed at the zero points of the two axes. The Show axis option in both axis options menus is unchecked.
Note that while Numbers will correctly place x,y data points on the chart regardless of the order in which the pairs are listed in the table, it will connect those points in the order they are listed, leading to some interesting curves when the pairs are not sorted by their x value component.
For a more Excel-like approach to graphing, you might take a look at the open source Office applications, OpenOffice.org, LibreOffice, or NeoOffice.
For graphing functions (rather than data), see Grapher, which you'll find in the Utilities folder inside the Applications folder on your Mac.
Regards,
Barry
@YB24:
"Grapher.app is very good for graphing data. Explanation for that pages 31 to 36 of the "Instructions for Use - Grapher versions 1.1…2.2" you may download (free) on website <http://y.barois.free.fr/grapher/> page Documentation."
Thanks for that. i haven't done much exploring with Grapher. Must take a look at the manual.
Regards,
Barry
"For graphing functions (rather than data), see Grapher, which you'll find in the Utilities folder inside the Applications folder on your Mac.", Barry wrote.
Grapher.app is very good for graphing data. Explanation for that pages 31 to 36 of the "Instructions for Use - Grapher versions 1.1…2.2" you may download (free) on website <http://y.barois.free.fr/grapher/> page Documentation.
Axes positions are up to you, (x, y) data may become (y, x) data easily.
Data can be imported from Excel, Numbers, NeoOffice with one mouse click (see Appendix 1 page 69 same manual). Several thousands data are possible.
Grapher graphs are much better than those shown in Excel, Numbers, etc. The "Inspector" has a lot of presentation options for axes, scales, frame, points, colors…
Enjoy,
YB24
how can I reverse the values on the x and y axis to show data in different quadrants?
