Formula for Graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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