Plotting two datasets on a graph

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
 
M

MRT

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
 

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

Top