Duplicate the price column after the quantity column and plot the
quantity and the new price columns.

See
Drawing Supply and Demand curves in Excel
http://www.tushar-mehta.com/excel/ch...ly_and_demand/


On Tue, 13 May 2008 09:07:01 -0700, BW
wrote:

How do I switch the data on the X and Y axis? For instance, I am trying to
do a supply and demand chart, and I want Price to be on the Y axis. No
matter how I plot the data, Excel always defaults to the supply and demand
figures on the Y axis.

thank you!

BW