inverting aixs of chart

[Guest]

I am trying to create a graph. I need to know how to swap
the y and x axis around so that the graph sits the other
way.

 

[Katherine Coombs]

hi there,

if it's a column graph a quick cheat is to just change it to a bar graph (go
Chart-->Chart Type and make the change in there).

HTH,
katherine

 

[dvt]

if it's a column graph a quick cheat is to just change it to a bar graph
(go
Chart-->Chart Type and make the change in there).

And if it's not a column chart, go to...
http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#SwitchXY

 

[Jon Peltier]

Next time you make the chart, put the X values to the left of the Y
values (or above if the data is in rows).

- Jon