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

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

Go into Source Data/ Series... and swap the data in the X values and Y
values fields.
--
David Biddulph

"BW" wrote in message
...
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

David,

thank you for your response. I should have specified that I was using a
line graph. I realized that I should be using a Scatter Plot and have since
had succes doing exactly as you noted.

Thank you!

BW

"David Biddulph" wrote:

Go into Source Data/ Series... and swap the data in the X values and Y
values fields.
--
David Biddulph

"BW" wrote in message
...
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