plotting multiple x-y data sets on 1 graph

[mousemouse]

I have data from a manually done discrete event simulation. variable x is days while variable y is total output. data looks like such:

set A
data point 1: (1,100)
data point 2: (2,200)
data point 3: (3, 350)

set B
data point 1: (1,100)
data point 2: (1.5,280)
data point 3: (2.5, 400)
data point 4: (3,500)

The data sets are much larger in reality and the data points vary from 1 set to another. I need to just compare the sets on 1 graph with the x axis being days (time scale) in intervals of 1 while having multiple lines for the output. I'm having a hard time getting excel to combine the data. any ideas?

thanks

 

[milesUK]

Select one range of x & Y data. Insert chart - Scatter.
Right mouse click on the chart & "Select Data".
<Add>.
Choose new range.

Hey Preston! Or it is on 2007 anyway.

Hope that helps.

 

[mousemouse]

thanks, the scatter plot worked!

 

[milesUK]

Excellent.