Sign up ×
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 '14 at 9:34

2 Answers 2

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 '14 at 9:33
Yes, a welcome improvement in Number 3 from Numbers 2! – Ian C. Jun 28 '14 at 16:42

Was able to do the same thing in Numbers 2009 (v2.1), but had to fiddle a lot. Use the 2-axis format. The program resists you all the way.

Here is a 2-axis graph (climate diagram) created using Numbers 2.1:

share|improve this answer
Could you perhaps expand your answer with specific instructions as to how the graph in the screenshot was created? – grgarside May 14 at 19:26

Your Answer


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.