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

  • Thread starter Thread starter joyo
  • Start date Start date
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?
 
Select the entire range you want to graph such as a2:b44>insert>chart>>>>
 
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
 
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
 
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?
 
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.
 
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
 
You must log in or register to reply here.

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

Time graphs 8
Calculation of Area Under a Continuos curve......Scatter Curve. 0
Chart (scatter plot): values on X-axis. 1
Sr. Citizen Question On Adding A Trendline, Please ? 1
Plotting with 3 columns data (X,Y and Values) 1
Plotting data points on 2 axis 4
Trendline Showing Problem ? 2
How to draw a graph with the X axis as a time line of date. 4

Back
Top