Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

One of my main problems with Numbers is the fact that it has much less of the functionality of Excel. That's why I barely use Numbers.

One of the main things that I always thought impossible was plotting two axes on one graph. This is my main reason for my dislike of Numbers.

Now that many other interesting questions that I didn't think had answers are getting answered, I thought I might ask this question:

How can I plot two lines on one graph using a secondary axis in Numbers?

share|improve this question
    
I think the accepted answer for this should now be changed as this is now possible. –  Nick Hawes Jun 28 at 9:34

1 Answer 1

If you want a line graph with 2 y-axes. You to insert->Chart-> 2-Axis. Put in your data. One of the sets will be a line the others a bar. The way to fix that is: Select the one that is a bar then to go to the Inspector-> Chart-> Series. It will say series type-> select that and change it from bar to line. Right below that it says plot on: There you can determine if you want that line to be plotted on y(1) or y(2).

What it looks like at first for 2-axis

share|improve this answer
    
"2D 2-Axis" is the chart type in Numbers 3.2. –  Nick Hawes Jun 28 at 9:33
    
Yes, a welcome improvement in Number 3 from Numbers 2! –  Ian C. Jun 28 at 16:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.