Thread: Swap axes on a scatter graph
View Single Post
  #2  
Old October 31st, 2006, 02:15 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
  
Posts: 4,085
Default Swap axes on a scatter graph
see http://peltiertech.com/Excel/Charts/axes.html#SwitchXY
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"xxx8langrd" wrote in message
...
Anybody know of an easy method of swapping the x and y axes over on a
scatter
graph. ie so that the data graphed as the y-axis data becomes the x-axis
and
vice versa. I have data for two values of Q and one of P in a supply and
demand diagram. The Q comes out on the vertical axis whereas an economist
requires P on the verical axis and Q on the horizontal. There are two
lines
that cross at equilibrium