Moving axis on charts

Feature unavailable.

My own workaround :
multiply all the values by -1

build the chart
Inspector > Measures

Flip the chart

This way, the curve is correctly below the axis.
If only some of the values are negative, build the standard chart but don't display the horizontal axis.
draw one thru the Shapes menu.

Of course it would be a good idea to
_Go to "Provide Numbers Feedback" in the "Numbers" menu,_ describe what you wish.
Then, cross your fingers, and wait at least for iWork'11

Yvan KOENIG ( VALLAURIS, France ) vendredi 3 septembre 2010 19:25:41

I found the same problem. I am trying to get a decent plot of the cosine and sine functions out of Numbers such as would be produced by MATLAB or Mathematica, and having a hard time doing so. The charting seems to be geared towards people doing category type plots, not scientific plots. Cosine goes from -1 to 1 and so the x-axis should go in the middle of the graph. Also, I would like to see an arrow on the axis at the end of it, but that doesn't appear to be possible. Another issue is that I have 24 points which go from 0 to 2*pi, but when I set the scale on the x-axis I can't set it to radians so only 6 points get plotted. DOH! Yet another issue is that I don't want little circle markers for each point, but again it seems impossible to turn these off.

dc,

Spend an evening with a pot of tea and the Numbers User Guide PDF. It will be worth your time.

Use Grapher.app for graphing functions. Use Numbers for charting data.

Jerry

dch888 wrote:
Cosine goes from -1 to 1 and so the x-axis should go in the middle of the graph. Also, I would like to see an arrow on the axis at the end of it, but that doesn't appear to be possible. Another issue is that I have 24 points which go from 0 to 2*pi, but when I set the scale on the x-axis I can't set it to radians so only 6 points get plotted. DOH! Yet another issue is that I don't want little circle markers for each point, but again it seems impossible to turn these off.

This is about the best cosine plot that's easily achievable with Numbers.



Values are calculated in the chart, using
=2 PI()(ROW()-2)/24

and
=COS(B)

The chart type is a scatter chart—the only non-category type available. Data points connected with a Curve and data point symbol set to None.

X axis at y=0 is an overlaid 'line with single arrow' shape.

Max on X axis set (manually) to the value in B26.

Should be easy to reconstruct after perusing the User Guide mentioned in Jerry's post, but I'd still go with his recommendation regarding using Grapher.app for this.

Regards,
Barry

I'm talking about the iPad version. It doesn't have the option to change the marker type, or change the max value based on a cell reference. Thanks for the ROW() tip and line with arrow head idea. Tea won't help, don't drink the stuff!

The discussion area for the iPad version of Numbers is here: http://discussions.apple.com/forum.jspa?forumID=1371

Jerry