swap axes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a line chart, Excel seems to predetermine the category axis - how can I
swap this so that my Y-value axis appears along the bottom?
 
Hi,

I've got the same problem as Fridgemaster. Andy, good try, but your solution
is not what we are asking. Primarily, we want to know how swap the x-axis
with the y-axis.

Please let me know if anyone finds a way to deal with this software which
thinks humans are too stupid to decide how they want to represent their chart.
Thanks!

Alex
 
Hi,

In what way is it not what you are asking.
Assuming a line chart, xaxis is categorical and yaxis is value, the
example explains how to swap them.

If the line chart is really a xyscatter with values on both axes then
you can just change the range references.

Cheers
Andy
 
Back
Top