Here is an illustrated tutorial which is similar to David's suggestion:

http://peltiertech.com/Excel/Charts/FormatMinMax.html

Your example would have dates in column A and values in column B. Put the
max allowed into cell E2 and the min allowed into cell F2. The formulas in
C2 and D2 a

=IF($B2$E$2,$B2,NA())=IF($B2<$F$2,$B2,NA())Fill these down columns C and D,
then make a chart using column A as the X values and columns B through D as
Y values for three series.- Jon-------Jon Peltier, Microsoft Excel
MVPTutorials and Custom SolutionsPeltier Technical Services, Inc. -
http://PeltierTech.com_______"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