View Single Post
  #1   Report Post  
smintey
 
Posts: n/a
Default Creating an x,y coordinate chart

I have a spreadsheet with two collumns of numbers in collumns A and B. I want
to produce a chart where collumn A produces the X axis values and B produces
the Y values. I want excel to plot the points where the values are and create
a line chart by joining these points up. I cant seem to get it to work!
Does anyone have any ideas???
Oh and if it makes a difference some of the values in the A (X axis) collumn
are negative so the chart would need to be able to display the negative
values in hthe x axis aswell.

Thanks in advance everyone!

Steve