ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Swap axes on a scatter graph (https://www.excelbanter.com/charts-charting-excel/116892-swap-axes-scatter-graph.html)

xxx8langrd

Swap axes on a scatter graph
 
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

Bernard Liengme

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





All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com