GamingResources
Registered User.
- Local time
- Today, 00:56
- Joined
- May 27, 2005
- Messages
- 13
Hello:
Here's the situation (yes, db not yet normalized, in process), I have data in which I want to place on a graph. Well, the data is as followed:
Expr1 SumOfACT-08CUP DR-08CUP
6/1/2005 5279 10614
6/10/2005 13495 10614
6/13/2005 15039 10614
6/14/2005 3273 10614
6/15/2005 4711 10614
6/16/2005 6532 10614
6/17/2005 22011 10614
6/2/2005 8841 10614
6/20/2005 3732 10614
6/21/2005 7968 10614
6/22/2005 10344 10614
6/23/2005 12004 10614
6/24/2005 13916 10614
6/27/2005 17707 10614
6/28/2005 11624 10614
6/29/2005 6492 10614
6/3/2005 21320 10614
6/30/2005 9030 10614
6/6/2005 4997 10614
6/7/2005 6192 10614
6/8/2005 10771 10614
6/9/2005 7757 10614
SUM of ACT - 223035 (first column of data)
SUM of PDT - 233508 (figure from custom calc on data above)
With all the data said above, basically, the goal trying to be achieved is the following - http://www.gamingresources.com/chart/sample_weigh_data_01.pdf
That is the ultimate goal trying to be achieved. The figures above are coming from Queries (2 queries).
LAYOUT: (on .pdf listed above)
1) Bar graph (itemized listing - 1st column of data - Query 2)
2) Line graph (listing - 2nd column of data - Query 1)
3) Yellow Bar graph - AT END (figure from column 1 in Query 2)
4) Red Bar Graph - AT END (figure from column 2 in Query 2)
Now, obviously there is a secondary axis which scales depending on the last 2 bars. Anyone have any idea on the direction I should go with this on getting this to be created within Access?
PLEASE HELP ME ON THIS!!! Would be so much appreciated!!!!
The .pdf above shows a graph customized in EXCEL. I'm trying to get this to automate within Access without having to customize each graph. Any ideas??????
Here's the situation (yes, db not yet normalized, in process), I have data in which I want to place on a graph. Well, the data is as followed:
Expr1 SumOfACT-08CUP DR-08CUP
6/1/2005 5279 10614
6/10/2005 13495 10614
6/13/2005 15039 10614
6/14/2005 3273 10614
6/15/2005 4711 10614
6/16/2005 6532 10614
6/17/2005 22011 10614
6/2/2005 8841 10614
6/20/2005 3732 10614
6/21/2005 7968 10614
6/22/2005 10344 10614
6/23/2005 12004 10614
6/24/2005 13916 10614
6/27/2005 17707 10614
6/28/2005 11624 10614
6/29/2005 6492 10614
6/3/2005 21320 10614
6/30/2005 9030 10614
6/6/2005 4997 10614
6/7/2005 6192 10614
6/8/2005 10771 10614
6/9/2005 7757 10614
SUM of ACT - 223035 (first column of data)
SUM of PDT - 233508 (figure from custom calc on data above)
With all the data said above, basically, the goal trying to be achieved is the following - http://www.gamingresources.com/chart/sample_weigh_data_01.pdf
That is the ultimate goal trying to be achieved. The figures above are coming from Queries (2 queries).
LAYOUT: (on .pdf listed above)
1) Bar graph (itemized listing - 1st column of data - Query 2)
2) Line graph (listing - 2nd column of data - Query 1)
3) Yellow Bar graph - AT END (figure from column 1 in Query 2)
4) Red Bar Graph - AT END (figure from column 2 in Query 2)
Now, obviously there is a secondary axis which scales depending on the last 2 bars. Anyone have any idea on the direction I should go with this on getting this to be created within Access?
PLEASE HELP ME ON THIS!!! Would be so much appreciated!!!!
The .pdf above shows a graph customized in EXCEL. I'm trying to get this to automate within Access without having to customize each graph. Any ideas??????
Last edited:
