View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
BW BW is offline
external usenet poster
 
Posts: 49
Default Switching X and Y axis

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