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....