S
SLK41565
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.
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.