market demand curve

[5dolla]

Was wondering if anyone has ever created a market demand curve chart in excel, with the prices on the vertical axis (2, 4, 6, 8, 10...) then what each user is going to pay in different columns so John will pay for 4 comic books at 2 bucks a piece, Liz will pay for 36 comic books at 2 bucks a piece and Alex will pay for 24 comic books. Then at 4 bucks, john is willing to pay for 4 at 4, Liz will pay 32 at 4, alex will pay 20 at 4 and so on. When I try to create a line chart or scatter chart, the price ends up on the bottom and I don't know how to switch it to the vertical instead of on the horizontal. I have tried moving the price column from the first column to the last and still the same thing.

If anyone knows if this can be done? I'm using MS excel 2007.

[5dolla]

I got it.

I guess if you want the price on the left of the chart and the individual values represented on the bottom of the chart, in column A of the Excel spreadsheet I put my 1st set of values and the price in column B, then a blank row, then the next set of values for your second curve below the first set (column A), then the same set of prices next to it (column B again). This gave the results I wanted. So for a demand curve with multiple values for example, the layout is like this:

A | B
______
36 | $2
32 | $4
28 | $6
24 | $8
<blank row>
24 | $2
20 | $4
16 | $6
12 | $8
<blank row>
...etc...

Then of course I just select everything in both columns and do a scatter graph. Hope that helps someone else b/c I couldn't find jack.

L8RZ