software

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,

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Have a look at Jon Peltier's page
gt; peltiertech.com/Excel/Charts/Y_CategoryAxis.html
gt;
gt; Cheers
gt; Andy
gt;
gt; Fridgemaster wrote:
gt; gt; In a line chart, Excel seems to predetermine the category axis - how can I
gt; gt; swap this so that my Y-value axis appears along the bottom?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

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

Alex Tay wrote:
gt; Hi,
gt;
gt; I've got the same problem as Fridgemaster. Andy, good try, but your solution
gt; is not what we are asking. Primarily, we want to know how swap the x-axis
gt; with the y-axis.
gt;
gt; Please let me know if anyone finds a way to deal with this software which
gt; thinks humans are too stupid to decide how they want to represent their chart.
gt; Thanks!
gt;
gt; Alex
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Hi,
gt;gt;
gt;gt;Have a look at Jon Peltier's page
gt;gt;peltiertech.com/Excel/Charts/Y_CategoryAxis.html
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;Fridgemaster wrote:
gt;gt;
gt;gt;gt;In a line chart, Excel seems to predetermine the category axis - how can I
gt;gt;gt;swap this so that my Y-value axis appears along the bottom?
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info