Thanks David

Not sure how this will work. the values are supplied to me and i am trying
to show the trend over time for others to view. I have to keep a static axis
to allow us to seperate the out of range values.

I was hoping to use something similar to the Error bars, just to highlight
if the value was above or below the normal.

Thanks for your help and time.
Phil

"David Biddulph" wrote:

The best bet is to use a formula put these values in a separate range, and
plot that range as a separate series.
e.g. =IF(A2max_limit,A2,NA())
--
David Biddulph

"PTaz" wrote in message
...
Hi

I am storing data (pulse rate) and displaying it in a line chart over a
period of time. I can set this up with no problems.

I have set ranges for minimum and maximum values (no ones pulse should be
below 40 or above 100 for example) I have set my Y axis to these values.
and
My X axis is my dates.

The problem i have is that sometimes the value drops below or goes above
the
set ranges. I am looking for a way to highlight these values on the chart.

Any help or advice would be appreciated.

Thanks
Phil