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
|