A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

cross tab query to graph



 
 
Thread Tools Display Modes
  #1  
Old September 16th, 2008, 03:44 PM posted to microsoft.public.access.tablesdbdesign
SLK41565
external usenet poster
 
Posts: 1
Default cross tab query to graph

I am attemping to build a graph based on a cross tab query. The resulting
data looks something like this:
OperatorID 06 07 08 09
043 1465 1580 1670 1644
084 1533 1540 1563 1488
092 695 634 583 545
105 1790 1458 1510 1520
115 2461 2412 2446 2385
132 1824 1842 1692 1754

This is based on a form with input dates and carries data for 90 days. I
have been successful in getting the right data points under the correct
operatorID. However, now I have three distinct issues. Any help will be
appreciated.

1- I need for each data point to be connected by a line. IE for operator
043 the points for 06, 07, 08 and 09 must be connect by a line.

2- The X axis needs to follow the operator ID scale. At present it does
somewhat, it goes from 0 to 1000 and the datapoints are in line with the
relative area the ID would be. However I need it to show 043, 084, 092, 105
etc. All subsequent graphs have done this.

3- Performance level ratings will need to be shown on the graph (y axis).
Level 2 at 4500, level 3 at 5525 to level 5 at 8600. Graph scale is large
enough for all levels, I just need a line or color on the backgroud to show
where the levels change.


Now that I have successfully given all a headache, I put this question to
the community.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.