Excel - Multiple subsets of data on one line graph

Question

I'm trying make a line graph that has multiple lines on it, each representing a question number and its data. I cannot get it to display properly. My data is structured like this...

Question Precision      Time
0        30.49849888    2000
0        31.44534664    3000
0        16.87857557    4000
0        48.49384985    5000
1        30.49849888    2000
1        31.44534664    3000
1        16.87857557    4000
1        48.49384985    5000

The data goes up to 5 questions. How can I create a single line graph in Excel that has separate lines for each question?

I plan to use time on the x axis and precision on the y.

Answer 1

The simple way to achieve your goal is:

1. Create a chart with single data series for Q1

   2. Right-click on the chart, select "Select Data..." option and then Add Series for another data range (Q2)

3). Repeat this for the rest.

Regards