I have data that comes back from a database in this format, but when I go to setup the chart series (products), it tries to make a separate grouping for each combination of Product+Date.

I want products as the series, date as the category and Val as the value. Is this possible from this format or am I going to need to loop through the data and put each product into a separate column?

Product__Usage Date________Val
A________10/8/2005_________4205
A________3/4/2007__________4303
B________10/8/2005_________8979
B________10/15/2005________7171
C________10/22/2005________6251
C________10/29/2005________3955
C________11/5/2005_________5314