chart waterline

B

Barry

I am looking to add 1 or 2 hard coded lines into my access charts to identify
a danger level and critical level.

I have a sample table:
process 1 date(01/01/06) level 40
process 1 date(01/02/06) level 45
process 1 date(01/03/06) level 50

process 2 date(01/01/06) level 30
process 2 date(01/02/06) level 35
process 2 date(01/03/06) level 40

process 3 date(01/01/06) level 30
process 3 date(01/02/06) level 42
process 3 date(01/03/06) level 50

Danger Level = 75
Critical level = 80

My chart should look like:
Day of Month - XAXIS
Process 1 should have 3 charted points (connected)
Process 2 should have 3 charted points (connected)
Process 3 should have 3 charted points (connected)
There should be a solid line across the board for Danger Level at point 75
There should be a solid line across the board for Critical Level at point
80

Hope someone can help!
Barry
 
Top