469,090 Members | 1,310 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Line Graph comparing years Collections

171 100+
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
  1. SELECT Sum(tblCollections.CollectionAmt) AS SumOfCollectionAmt, Format([CollectionDate],"yy/mm") AS Collected
  2. FROM tblCollections
  3. GROUP BY Format([CollectionDate],"yy/mm");
Line Values: SumOfCollectionAmt
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.
Nov 9 '09 #1
0 1355

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

13 posts views Thread by Tim Henderson | last post: by
7 posts views Thread by news | last post: by
reply views Thread by -cicada- | last post: by
3 posts views Thread by goldreads | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.