Copy a polynomial from a chart to a worksheet
Posted by Jesper from Sweden on October 13, 2001 2:51 AM
Here's a problem that I am often faced with.
From a series of x-values and y-values I create a chart as XY-scatter. I insert a trendline, usually a polynomial of the second or third degree. If I want to use this polynomial on a worksheet I copy it as text and change "x" to the cell I want to use as x-value. If I change the values that the trendline is based on, I have to copy it to the worksheet again.
Now to my question. Is it possible to link the trendline to a worksheet so it gets automatically updated? Or is it possible to calculate a polynomial from a series of data directly on the worksheet without using a chart?
Thanks