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
add comment

2 Answers

up vote 1 down vote accepted

As of Numbers '09 (version 2.1) this still isn't something you can do within Numbers. You could export your charts and superimpose them, but that's obviously a horrible kludge.

Your best approach is to select File -> Provide Numbers Feedback from the menu and let Apple know you'd like to be able to do this in Numbers.

The Numbers axis properties pane

share|improve this answer
    
Owch. I was really hoping for something that would let me do secondary axes. Oh well. Thanks anyway. –  JavaAndCSharp Mar 28 '12 at 10:26
add comment

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
add comment

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.