473,320 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Line Graph comparing years Collections

171 100+
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:
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");
  4.  
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 1462

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

Similar topics

13
by: Tim Henderson | last post by:
Hi I want to dynamically generate a graph in python that would be displayable on a web page. What would be the best way to do this? The reason I want to do this, is because I am making a program...
7
by: news | last post by:
This may be a stupid question, but if I don't ask I'll never know ;) Ok, here it goes.... I am writing an application that renders an image in one picturebox and a graph in another. The image...
1
by: Roger Oshaug | last post by:
Access 2003 I have a simple line graph with one line and I need an extra horizontal line in that graph. I want something similar to this, (without the vertical line): ...
1
by: gihope | last post by:
Hi, I wonder if someone could help me. I'm trying to develop a search algorithm as I need an engine that can determine the shortest route between two locations based on the number of stops. I...
6
craigfr
by: craigfr | last post by:
I am looking to compare this year's defects to last year's defects (by month) with a two-line graph. So I will need a line chart with two different lines, one that shows YTD # of defects and another...
0
by: mylog | last post by:
I have downloaded a GLEE(Graph Layout Execution Engine) and written the following code to display a windows form from a web page but i am encountering with a small problem on displaying the graph...
0
by: -cicada- | last post by:
Hello All, I have a database of various artist's average annual auction prices, which I would like to graph. In some years there are no sales for an artist, and therefore no data for that artist...
3
by: The Frog | last post by:
Hi guys, I have never touched really on this area before with forms and reports, and now I would like to be able to incorporate some graphs / charts for a new little app I am building, and I...
3
by: goldreads | last post by:
Hey guys, I've been putting together a line graph in Image_Graph. And I can't seem to find an answer to change the layout of few things. Here is my graph: http://www.goldreads.com/test.png ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.