Insert line at value 'x' on y axis

[Dale]

HI all
I have a graph in ms access 97 where I would like to have a "target" line
which is simply a dotted line colored red, drawn on the graph at a set point
"x" on the y axis. The purpose of the line is simply a visual tool to
quickly show which values are above or below the "target".

I've drawn the target line on the graph using the line tool, however as new
data is added and the values on the y axis change (to accomodate new
values), I must continually readjust the target line manually.

Is there a way to draw this line at value x using code? Thanks in advance.

 

[Guest]

Add a series to your query used for the chart source with the value of your
target like:

Field: Target: 0.95

If you run the query you'll see how this value repeats for all your data
points, now add that series to your chart and format it the way you need

 

[Dale]

Thanks so much...that does the trick. Sheesh....I should have thought of
that!!