Excel 2007 : Chart using distinct values in a column

[sniles]

I have a table that looks like this:

time, ID, value
10:00, 20, 14.75
10:00, 21, 17.32
10:01, 20, 15.21
10:01, 21, 17.89

and I want to make a line chart where the x-axis is time, the y-axis is value, and there is a different line for each distinct ID

i.e. one line for 20 that goes from 14.75 to 15.21 to...etc
and another line for 21 that goes from 17.32 to 17.89
and so on

it seems like something excel (2007) should be able to do, but I'm not sure how to do it

[Andy Pope]

Charts will not summarize or sort out your data. You have to prepare the data for the chart.

You would need formula or possibly a pivot table to summarize your data first