Hi there,
I was just wondering when you place a trendline on a graph and choose to have the equation of said trendline displayed, is there anyway of copying the coefficients of each term into cells automatically?
For example if the equation was y = 3x^3 + 2.5x^2 + x + 3.6
It would read:
A1: 3
A2: 2.5
A3: 1
A4: 3.6
Any help would be much appreciated!
Bookmarks