I am having problems with plotting 2 seperate columns against each other. I
have one column of data that needs to be the X axis and one column of data
that needs to be on the Y axis and they need to be plotted against each
other, but when I try to create a chart, it will not let me plot these 2
columns against each other but merely as 2 different data series. Please
help.

To plot two columns against each other in Excel:

1. Select the two columns of data that you want to plot against each other.
2. Click on the Insert tab in the ribbon at the top of the screen.
3. Click on the Scatter chart type in the Charts section.
4. Select the type of scatter plot you want to create. The default option is usually fine.
5. Excel should automatically create a scatter plot with your two columns of data plotted against each other.

If Excel is still not letting you plot the two columns against each other, make sure that you have selected both columns of data before creating the chart. If that doesn't work, try switching the columns around so that the X axis data is in the first column and the Y axis data is in the second column.

I hope that helps!

Hi Andrew,

Go to the series section in the wizard. Make sure only one series
exists. In the options for that series, select your X axis values by
clicking in the x-axis values box and selecting the cells in your
sheet. Do the same for your y-axis values.

Are you using an XY scatter graph?

David

Andrew wrote:

I am having problems with plotting 2 seperate columns against each other. I
have one column of data that needs to be the X axis and one column of data
that needs to be on the Y axis and they need to be plotted against each
other, but when I try to create a chart, it will not let me plot these 2
columns against each other but merely as 2 different data series. Please
help.

Well I wanted to use a line graph to represent the data. Is that possible?

"Darv" wrote:

Hi Andrew,

Go to the series section in the wizard. Make sure only one series
exists. In the options for that series, select your X axis values by
clicking in the x-axis values box and selecting the cells in your
sheet. Do the same for your y-axis values.

Are you using an XY scatter graph?

David

Andrew wrote:

I am having problems with plotting 2 seperate columns against each other. I
have one column of data that needs to be the X axis and one column of data
that needs to be on the Y axis and they need to be plotted against each
other, but when I try to create a chart, it will not let me plot these 2
columns against each other but merely as 2 different data series. Please
help.

Not as far as I'm aware. An XY scatter looks exactly the same as a line
graph if you select the correct type, it just has more functionality,
allowing what you're trying to do.

David


Andrew wrote:

Well I wanted to use a line graph to represent the data. Is that possible?

"Darv" wrote:

Hi Andrew,

Go to the series section in the wizard. Make sure only one series
exists. In the options for that series, select your X axis values by
clicking in the x-axis values box and selecting the cells in your
sheet. Do the same for your y-axis values.

Are you using an XY scatter graph?

David

Andrew wrote:

I am having problems with plotting 2 seperate columns against each other. I
have one column of data that needs to be the X axis and one column of data
that needs to be on the Y axis and they need to be plotted against each
other, but when I try to create a chart, it will not let me plot these 2
columns against each other but merely as 2 different data series. Please
help.

If your data is arranged in a certain way, you will be able to do more with
less effort.Five minutes with the data might prevent five hours of
teeth-gnashing.

First of all, Microsoft did nobody any favors with its terminology of line
and scatter charts. The differences are not with the formatting of the
series, which you might notice if you see what subtypes are available. The
differences are with the treatment of the X data and the X axis:

http://pubs.logicalexpressions.com/P...cle.asp?ID=190
http://peltiertech.com/Excel/ChartsH...ValueAxis.html

Second, it's always best to put the X column to the left of the Y column.
Immediately to the left is better, but not critical, because you can select
multiple areas using the ctrl key. If you have headers for the columns,
resist the urge to put a header on the X column. The blank tells Excel that
something is different about this column, so it will try to make it into a
category column. Actually if you create an XY chart, Excel uses the leftmost
column for X by default.

If you are still unable to make use of a standard arrangement of the data
columns, I've put together a small utility that lets you draw XY charts in
Excel using semi-regular data regions. It's still a beta type program, not
perfect yet (it won't be perfect until at least next week), but it's pretty
good. Try it he

http://peltiertech.com/Excel/ChartsH...rtUtility.html

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


"Andrew" wrote in message
...
I am having problems with plotting 2 seperate columns against each other.
I
have one column of data that needs to be the X axis and one column of data
that needs to be on the Y axis and they need to be plotted against each
other, but when I try to create a chart, it will not let me plot these 2
columns against each other but merely as 2 different data series. Please
help.