I have the following query
<CFQUERY NAME="QoQWeeklyHours" DBTYPE="Query">
SELECT WEnded, Executive, Sum(Qty) AS TotQty FROM WklyHoursQuery
GROUP BY WEnded, Executive
ORDER BY WEnded, Executive
and I want to create a line graph with lines for each executive showing TotQty for each WEnded (week ended date). I have spent hours trying to get something to work but I just end up in a mess. Any help greatly appreciated.