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:
Expand|Select|Wrap|Line Numbers
- SELECT Sum(tblCollections.CollectionAmt) AS SumOfCollectionAmt, Format([CollectionDate],"yy/mm") AS Collected
- FROM tblCollections
- GROUP BY Format([CollectionDate],"yy/mm");
Horizontal Axis:Collected
Vertical Axis: SumOfCollectionAmt
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.