swap axes

[Fridgemaster]

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?

 

[Andy Pope]

Hi,

Have a look at Jon Peltier's page
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

 

[Alex Tay]

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

 

[Andy Pope]

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