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