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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|