Creating S&D diagrams in Excel

[John Ryan]

I'm trying to make simple supply and demand diagrams in excel but its
not working the way I want it. This is my worksheet:
Price Qd Qs1 Qs2
0 10 0 0
1 8 2 2
2 6 4 4
3 4 6 6
4 2 8 8
5 0 10 10

....that I want to make a graph of. So I use the wizard, but *no
matter* what I do the price is always on the X-axis and the quantity
demanded on the Y. How do I change this?? I assume it's something
simple with the formula thing but I don't understand that at all.

Thanks in advance

 

[Matt]

Which Chart are you choosing when you run the Chart Wizard?

I may not be understanding your question completely, but
when I select the data and run the Chart Wizard and choose
a Column Chart, the Column Headings (Price, Qd, Qs1, and
Qs2) are along the X-Axis and the Values (0-12) are along
the Y-Axis.

If you want to switch the X and Y-Axis you need to choose
if the Series is in Rows or Columns on Step 2 of the
Wizard.

Matt