Graph only shows one series

Graph only shows one series

I have built a query table that contains data regarding golf scores. It has the following columns: player, course, total (this is a sum of other columns in the main table), date.

I want to graph the following:

X axis is date
Y axis is total

the data points are filtered by a couple of players and a course. I can't get the graph to split out the players individually. it works fine for one player/one course but i want to compare players on the same graph.

How can i get the graph to do this?

Thanks for any help.

Tim

Query table is as follows:

SELECT course, player, hole1+hole2+hole3+hole4+hole5+hole6
+hole7+hole8+hole9+hole10+hole11+hole12
+hole13+hole14+hole15+hole16+hole17+hole18 AS "Total", "date"
FROM matches
order BY course, player, "date";