473,383 Members | 1,837 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,383 software developers and data experts.

Monthly Line Chart

Hello Everyone,

I have run into a problem with creating a line chart in access. My ultimate goal is to have the chart produce monthly totals for the salesmen and also show there quotas for the month. The salesmen data is in 1 table and the quotas are in the other. In the salesmen data table I have Sale date, Won price, Salesmen and other misc fields. In the quota table it is a simple month to month break down of salesmen and there quotas(Columns: Date, Salesmen, Quota)

For that chart I am trying to have the Y axis as won price. The X axis as month and the data showing the salesman's won price and a separate line depicting there quota over those months(basically comparing the two.

I have been trying to figure out how to do this for a few days and I have also been searching the web for any hint of how to do what I want with little success. Any help on this would be much appreciated.

Thank You,
Sean
Sep 17 '10 #1
3 2526
If this is not possible to do. I am willing to make separate line charts for each salesmen.
Sep 20 '10 #2
Mariostg
332 100+
You should specify which version of Access you are using. Chart abilities probably are different from Access 2003, which is the one I used, from Access 2010.

I always found chart abilities of access to be rather limited. I prefer to export formatted data into Excel then plot it from there. All this can be scripted.
Sep 20 '10 #3
Thank you for the tip. I am currently using Access 2007
Sep 20 '10 #4

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

Similar topics

0
by: Anks | last post by:
I need to display a printable line chart on client machine using jsp/servlet. Is it possible ?Please explain? Anks
1
by: Frank | last post by:
I've written a jsp that retrieves data from a sybase table via the sql JSTL. Two colums of data are returned, date and value. Currently the data is placed in an HTML table. Does anyone know of...
3
by: Serdar C | last post by:
hello there.. there used to be a usefull and simple control on vb6.0 which was a line chart.. it was quite easy to use.. but in c# theres a pani named "crystal reports" and its too much complicated...
5
by: Zach | last post by:
Hi, I am completely new to VC#.NET graphics code and would like some help to stop me wasting my time up blind alleys. I am looking for a line charting code example. Nothing posh or airy...
5
by: Bruce Schechter | last post by:
I need to generate a series of line charts dynamically from ADO.NET data in a C#, ASP.NET application. I've read several articles about using GDI+ to render graphs into a bitmap image and then to...
1
by: Scott H. | last post by:
Hello: I am trying to use Crystal Reports from VS.NET 2003 to produce a simple line chart, where the x axis represents the number of measurements taken and the y axis represents the range of...
0
by: zenius | last post by:
Can anyone please give me an example how to create line chart graphic using VB.NET
4
by: =?Utf-8?B?bWFydGluMQ==?= | last post by:
Hi, All, I want to draw line chart on the web using visual basic 2005, vb 2005 doesn't have chart components, so can anyone point out where I can start working this? Thanks, Ma
2
by: patradebashis | last post by:
Hi, Any body plz help me to create a Line Chart In Applet. I also need the source code . Thanks Debashis
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: 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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.