I need both of these graphs remade. Price has to be on Y axis

Paying 20fg (maybe more) each graph, has to look as good as these ones or better.





For graph 2
Ceiling = 400
Floor = 700

Bump

do you have this tables (and graphs) in a computer-program (excell or whatever) allready?
if so, you might just have to change the x and y data-columns

I used a website to do them, the second one is correct except y axis is on wrong side and the lines going opposite direction because of this. I tried swapping the x and y but it didn't come out right. I couldn't get them to work in excel

its a bit tricky in excel because you have to set up this thing over a scatter-plot with matched lines (instead of a line-diagram what one would expect first).

But you will be able to do it, its not hard at all.

copy the table to excel.
than you insert a scatter with straight lines and markers (no data highlighted when doing this).
now you hit the empty graph with the right mouse and click: select data.
emty the chart data range textfield and then push the add button on the left side (legend entrie).

a new box will open
for the series name you select the lable of the line (quantity demanded for example)
for the series x value you select all the fields containing quantities (for quantity demanded that would be: 70, 60, 50, 40, 30, 20)
for the y-series values you select all the prices (300, 400, 500, 600, 700, 800)
hit the ok button and the first line should be there (the one for quantity demanded).

next step:
hit the add button on the left side again.
do the same thing for quantity supplied

and once more for new quantity supplied


now you should have the graph with 3 lines.
by hitting the x and y labels with the right-mouse-button and selecting format axis you can change the value-ranges and stuff you might need on the axis.

hope that helps a little bit.

Ceiling is always greater than floor by the way. Dunno if it was said yet.

Thanks so much man, you really helped me. Got it working. Had to use paint to do the ceiling not sure if you can do it in excel. But it looks good thanks! Sending 100 fg as a thank you






Yep I know It was 2 separate questions that I did on 1 graph. I double checked it 'cos of your post and realized both were posed as ceilings in question. So I changed that, thanks!