ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Move from Y Axis to X Axis (https://www.excelbanter.com/charts-charting-excel/243221-move-y-axis-x-axis.html)

KenCanuck

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

John Mansfield

Move from Y Axis to X Axis
 
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[_2_]

Move from Y Axis to X Axis
 
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



All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com