A helper column =MIN(500,Y1)
or =IF(Y1="",NA(),MIN(500,Y1))
--
David Biddulph

"Amber" wrote in message
...
I have a graph that automatically updates each time a new X and Y value are
entered. I would like to know if there is a way to put a formula in for
my Y
values so that if the value entered is over 500, the graph will plot 500
and
not the actual number entered. Is this possible?

Thanks....