G Guest Oct 23, 2003 #1 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.
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.
K Katherine Coombs Oct 23, 2003 #2 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
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
D dvt Oct 23, 2003 #3 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). Click to expand... And if it's not a column chart, go to... http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#SwitchXY
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). Click to expand... And if it's not a column chart, go to... http://www.geocities.com/jonpeltier/Excel/Charts/axes.html#SwitchXY
J Jon Peltier Oct 23, 2003 #4 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
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