PDA

View Full Version : Working with Charts



leal72
09-23-2009, 10:40 AM
I want to allow the user to set the upper and lower limits of the curve to plot.

In cell "N14" the user would type in the low limit and in cell "N17" the high limit.

let's say the user wants 80 as the low and 175 as the high

Once those numbers are entered into the cells the curve will plot all the points with a value that is between 80 and 175.

The (X) xvalue is in column H and the (Y) value is in column G

Autofilter does this but the data is also used in other sheet(s) and using the Autofilter effects the other curves. Don't want that.

Bob Phillips
09-23-2009, 10:52 AM
Store the upper and lower values in cells, a helper column and a formula that tests if the real value is within those limits, something like

=IF(AND(B2>=E1,B2<=F1),B2,NA())

and chart the helper column.

leal72
09-23-2009, 02:16 PM
Thank you, I do appreciate the help.

So I should get a value of True or False, and from there use the True results to plot the curve?

Bob Phillips
09-23-2009, 02:22 PM
No, you wont get TRUE or FALSE, you will get the original value if in limits, otherwise you will get #N/A, which won't plot.

leal72
09-23-2009, 02:36 PM
Thanks, got it working!