Move from Y Axis to X Axis

KenCanuck · External Since: Sep 20, 2009 Posts: 1

How can I get my data from being displayed on the Y Axis to moving it to the
X Axis? Thanks

John Mansfield · External Since: Mar 21, 2007 Posts: 92

It depends on the type of chart your using, but generally you can control
what appears on the X and Y axis by first activating the chart (click on the
outside edge with your mouse). Then, if using Excel 2003 go to the standard
toolbar and select Chart -> Source Data -> Series. Or, you can right-click
your mouse and go to Source Data -> Series.

--
John Mansfield
http://www.cellmatrix.net

"KenCanuck" wrote:

> How can I get my data from being displayed on the Y Axis to moving it to the
> X Axis? Thanks

A little stuck · External Since: Sep 01, 2009 Posts: 3

Go to the following site:
http://peltiertech.com/Excel/Charts/axes.html#SwitchXY
Click on 'Switch X any Y' on the list on the left hand side. Then click on
the link. Download the tool and voila!

"John Mansfield" wrote:

> It depends on the type of chart your using, but generally you can control
> what appears on the X and Y axis by first activating the chart (click on the
> outside edge with your mouse). Then, if using Excel 2003 go to the standard
> toolbar and select Chart -> Source Data -> Series. Or, you can right-click
> your mouse and go to Source Data -> Series.
>
> --
> John Mansfield
> http://www.cellmatrix.net
>
>
> "KenCanuck" wrote:
>
> > How can I get my data from being displayed on the Y Axis to moving it to the
> > X Axis? Thanks