Formula for Graphs
 

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

Formula for Graphs
 

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

Formula for Graphs
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Formula for Graphs
 

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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