VERY simple Numbers question!

[72930]

OK, so it seems like I'm an idiot, I can do this really easily in NeoOffice, but the charts from that app don't have the same look that Numbers' do...

How do I make a chart of these with a line between the results, with Price on the y-axis?

Price-----Quantity Supplied
5 ----------5
10 -------- 8
15 --------11
20 --------14
25 --------17
30 --------20

If I select the columns and create a chart of the type I want, I get:

 

[swiftaw]

If you click on Series you should be able to specify what values are on the x-axis and y-axis.

 

[notsofatjames]

try only highlighting the right column, tricking numbers to think that the price is a column heading.

 

[72930]

If you click on Series you should be able to specify what values are on the x-axis and y-axis.

I then get:

try only highlighting the right column, tricking numbers to think that the price is a column heading.

I get this, I could rename the y-axis manually, but that really would be a pain for a whole Economics course worth of charts...

 

[72930]

Sorry to bring up an old thread, but it turns out I'm dreadful at spreadsheets, and its kinda important. I have this set of data, and would like Price on the Y axis, and the others plotted as shown, in a scatter graph preferably with a line:

I have Numbers, Excel and NeoOffice, without a clue what to do in any of them. Please could someone tell me what to do?

Thanks in advance

 

[GregE]

You mean like this? I couldn't get your prices to be the Y axis though. Not that I spent a lot of time on it. All I did was highlight the data and then click on the charts icon and picked the style of chart.

 

[72930]

That is the stage I got to...having the price on the Y axis is necessary though, and rotating all the diagrams in a 2 year course is not ideal.

Thanks for your effort