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