Add second y-axis to chart

Question

Level 4

1,601 points

Add second y-axis to chart

Hi Everyone

I'm doing a formal report for a university project and would like to know how to add a second y-axis to a chart? I have 4 lines plotted on a scatter graph, 3 of the lines have values that are between 0 and 3 and the fourth line has values from about 1200 to 1500. I would like to add another y-axis so that the 3 smaller valued lines are on the second axis. All four lines must be plotted on the same graph with 2 y-axes.

I have tried searching the user guide but did not find anything

Thanks in advance
J.C

Message was edited by: J.C

AirPort Extreme, 32Gb iPod Touch 3.0, 15" MacBook Pro 2.4Ghz 2Gb RAM (Early '08), Mac OS X (10.5.7), 20" iMac Intel Core 2Duo 2.16Ghz 1Gb RAM, 20Gb 4th Gen iPod

Posted on Aug 23, 2009 5:49 PM

Reply

Answer 1

Aug 23, 2009 6:10 PM in response to J.C

J.C,

In this version of Numbers, there is no built-in option to add a second axis to a Scatter Chart. The way to do it is to create an auxiliary column with the 2nd axis data scaled to match the other series. Plot the scaled data and then, using text boxes or tables, add a second axis and labels to your chart manually.

Regards,

Jerry

Reply

Answer 2

J.C Author

Level 4

1,601 points

Aug 23, 2009 6:31 PM in response to Jerrold Green1

Thanks, I will have to use Excel. I will also send feedback to Apple in the hopes it will be in the next version of Numbers.

J.C

Reply

Answer 3

Aug 23, 2009 6:34 PM in response to J.C

J.C,

That's a good idea. There were many good enhancements in the second version of Numbers and many of them may have been influenced by feedback.

Jerry

Reply