Controlling which data appears on which axis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mwr7483 - 11 Aug 2006 08:44 GMT

Hi

I need help! I am doing an assignment and I need the data that I have
produced to appear on a particular axis. Here is my data:

0 1600
1 1400
2 1200
3 1000
4 800
5 600
6 400
7 200
8 0

After I select it and click the chart wizard button, the 0, 1, 2, 3
etc. data appears on the X axis, but I want it to appear on the Y axis.

How am I able to do this?!

Signature

mwr7483

Reply to this Message

Jon Peltier - 11 Aug 2006 13:36 GMT

Standard practice is to start with the X values in the left hand column, and
Y values to the right. This is also the easiest approach.

If you're unwilling/unable to rearrange the data, start the chart wizard, in
step 2 click on the Series tab. This dialog holds the key: you can define
which ranges are X and Y values on a series-by-series basis.

If the charts already exist and you don't want to spend the time to rebuild
them, you could try this:

http://peltiertech.com/Excel/Zips/SwitchXYAxes.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Hi
>
[quoted text clipped - 15 lines]
>
> How am I able to do this?!

Reply to this Message