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