swap axes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fridgemaster - 15 Mar 2006 13:00 GMT

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?

Reply to this Message

Andy Pope - 15 Mar 2006 13:13 GMT

Hi,

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

Cheers
Andy

> 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?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Alex Tay - 30 Mar 2006 14:08 GMT

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,
>
[quoted text clipped - 6 lines]
> > 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?

Reply to this Message

Andy Pope - 30 Mar 2006 14:22 GMT

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

> Hi,
>
[quoted text clipped - 18 lines]
>>>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?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message