Plotting two datasets on a graph

  • Thread starter Thread starter VICTOR
  • Start date Start date
V

VICTOR

Hi,

i have two datasets of X and Y Values. The first dataset has 48 pairs
of X,Y values. The second has 96 pairs. I wonder how i can plot this
on the same graph so i can compare them. Thanks in advance for your
suggestions. Thanks,

Victor
 
In the Chart type box, select XY (Scatter). (Not "Line")

Data range
series1, x: =Sheet1!$A$2:$A$49
series1, y: =Sheet1!$B$2:$B$49
series2, x: =Sheet1!$C$2:$C$97
series2, y: =Sheet1!$D$2:$D$97

HTH
 
Back
Top