How to use MSExcel to plot Column A against Col B?

J

joyo

I want to plot col A (x axis) against col B ( y axis). I cant seem to
do it. Can anyone here please give me step by step primer. Thanks in
advance.

All I get is the graph of (1,2,............n) (x axis) against the n
values of either col A or B.
i.e 2 graphs instead of one.

(In the old Lotus this was so simple: select the column for the X axis
and then select the col for the Y and press enter, and you'd get the
chart)
Why is it so diff in Excel?
 
A

Andy Pope

Hi,

It will if you create a xy-scatter chart rather than a line chart.

Also adding a textual series name over the second column and including
that row in the range selection will help the chart wizard use the first
column as x axis values/categories and the second column as y values.

Cheers
Andy
 
O

orbii

good question, trying to figure it out myself either... to clarify what he's
asking

x y
a 45 29
b 8 47
c 45 44
d 43 40


he's trying to plot that, where a is point 1 at coordinate (45,29) etc
etc...

happy new year, orbii
 
J

joyo

Andy said:
Hi,

It will if you create a xy-scatter chart rather than a line chart.

Also adding a textual series name over the second column and including
that row in the range selection will help the chart wizard use the first
column as x axis values/categories and the second column as y values.

Cheers
Andy
Click to expand...

Why must I use a scatter chart. i want to use a line chart. You mean it
cant be done on a line chart?
 
J

joyo

joyo said:
Why must I use a scatter chart. i want to use a line chart. You mean it
cant be done on a line chart?
Click to expand...

Ok yes I got it. It would seem like you said, I have to name the 2nd
column. geez what a lousy software! Anyone can help me where I can
download the lotus 1-2-3 for free? Thanks.
 
A

Andy Pope

If your x axis points are 1,2,3....n then you do not need the first
column of data, which is confusing the wizard, as it will automatically
create those categories for you.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to plot y against x 2
Calculation of Area Under a Continuos curve......Scatter Curve. 0
create chart with column axis 10
How to draw a graph with the X axis as a time line of date. 4
Trendline Showing Problem ? 2
Consolidate my data and plot on a dual axis chart 3
Aligning an excel table w/ a cluster column chart x-axis columns 2
How to not have formula change after inserting column from another sheet 1

Top