How do I put two sets of data on one line gaph

I have two sets of data that I would like to compare on one line graph, so the graph would have two lines, each line from its own data points. Is there any way to do this?

Hello,

just do the following:

  • select the range containing both data rows and

image description

  • Add graph using Insert -> Chart and Select XY(Scatter) in Choose a Chart Type and points and Lines

  • Click Next (3 times) if you want to check and/or add additional information
  • Click Finish and see the result

image description