I have a SQL query that retruns results that have mutiple values for the same header. example

------------- ------------ --------
TEST1 01/01/05 5
TEST1 01/02/05 6
(repeats many times)
TEST2 01/01/05 0
(repeats many times)

There are over 30 tests and 65000 lines in the worksheet. I want to graph this information so that I get i line graph that has the value of the date on the x axis and the value of the reply on the Y axis. I want to have a line for each test on the graph. Is there a way to do this?