A
Andrew
I've got a line with 52 data points for which I've put in a Polynomial Trend
Line degree 6 to provide a smooth profile.
The next stage that I want to do is to work out what the values are of the
Trend Line. Currently I display the equation on the Chart, copy it, paste
into a cell and adjust the format accordingly. Very long-winded, and the
process needs to be re-done every time the data is updated.
There must be an easier way. Something that involves a direct link and no
copy and pasting. Any ideas?
Line degree 6 to provide a smooth profile.
The next stage that I want to do is to work out what the values are of the
Trend Line. Currently I display the equation on the Chart, copy it, paste
into a cell and adjust the format accordingly. Very long-winded, and the
process needs to be re-done every time the data is updated.
There must be an easier way. Something that involves a direct link and no
copy and pasting. Any ideas?