Formula for Graphs

[Amber]

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

 

[David Biddulph]

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

 

[Bernard Liengme]

Let's say you chart uses x-values starting in A2 and y-values starting in B2
Right now you are adding values to the end of the A and B columns
Begin by copying the y-values (say B2:B100) to C2:C100
In B2 enter =MIN(500, C2) and copy this down the column
Now you chart plots the old y-values if below 500, or it plots 500
When you want to add more data, enter the x-value at the end of A and the
y-value at the end of C
You may need to copy the formula in B down one row as you go.
If this works for you, we can make some improvements.
best wishes

 

[Amber]

This worked perfectly....thank you for your help!