Switching X and Y axis

  • Thread starter Thread starter BW
  • Start date Start date
B

BW

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,

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
 
Back
Top