How can I use a secondary axis in Numbers? 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?
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).