Switching X and Y axis

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
 
D

David Biddulph

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
How do I put words as the Y axis values? 0
Make Y-axis values correspond to x- axis value 1
LIne chart problem 2
Chart distorts secondary axis when the x-axis is logarithmic 5
x and y axis 5
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4

Top