How do I assess whether something falls into an area on a chart?
 

I have drawn a graph with 3 almost parallel lines on. I would like to be able
to put in a result, eg 4.6 @ 6hrs and for excel to say whether it is under
the bottom line or in-between two lines or above the top.

Any thoughts please?

How do I assess whether something falls into an area on a chart?
 

You need to do that on the worksheet with the data, not on the graph.
--
David Biddulph

Zef wrote:
I have drawn a graph with 3 almost parallel lines on. I would like to
be able to put in a result, eg 4.6 @ 6hrs and for excel to say
whether it is under the bottom line or in-between two lines or above
the top.

Any thoughts please?

How do I assess whether something falls into an area on a chart?
 

Excel 2007 Chart
Assess target area.
With Tables, CF and colored target areas.
http://www.mediafire.com/file/qnwmoy...08_12_09a.xlsx