Not So Smart
07-21-2008, 06:38 AM
I have been creating scatter charts and then inserting Polynomal (6) trenlines. I can find the (Y) value on this chart visually with a ruler.
I would like to be able to use a user defined function (much like the "Forecast" function) to be able to get the exact (Y) value given an (x) value.
Does anyone know of a user function or other code to do this in Excel?
Thanks
David
I would like to be able to use a user defined function (much like the "Forecast" function) to be able to get the exact (Y) value given an (x) value.
Does anyone know of a user function or other code to do this in Excel?
Thanks
David