Charts with inconsistent X and Y data

[beegeeblueboy]

I'm trying to show two data series onto one graph. The number is records in both series are differrent for both Y and X e.g

Series 1 Series 2

X Y X Y

80 92 77 92
80 93 78 84
81 90 78 90
84 88 81 77

In particular there are multiple records for X in each series.

I'm flummoxed. Any suggestions would be most appreciated.

 

[GlennUK]

Do an X-Y scatter for one set of X-Y, then once the chart has been created add the other one.