Line Graph comparing years Collections

[iheartvba]

Hi,
I have a line graph which shows monthly sales, on the vertical axis it has the amount markers and on the horizontal axis it has month markers formatted in "yy/mm" format. The line shows the actual amount of sales for that "yy/mm" period. What I would like to do, is only have months on the horizontal axis, and have a different line for each year.

The underlying query is as follows:

SELECT Sum(tblCollections.CollectionAmt) AS SumOfCollectionAmt, Format([CollectionDate],"yy/mm") AS Collected
FROM tblCollections
GROUP BY Format([CollectionDate],"yy/mm");

Line Values: SumOfCollection Amt
Horizontal Axis:Collected
Vertical Axis: SumOfCollection Amt

I tried to print the chart to pdf but the file was 27 kilobytes and thus too big to attach. I can e-mail it to anyone who'd like to have a look.

Your help would be greatly appreciated.