Exporting polynomial equation coefficients from a chart into a cell

[tnp1996]

I have a groups of data that I am plotting in XY scatter charts and then fitting 2nd or 3rd order polynomial trend lines to the data. I am then having to manually type in the equations from the charts into cells and use the goal seek function to find "x" where "y=0". Is there not a function that can be used to export the coefficients into a group of cells or a macro that can be used to do this? I am having to do between 10 and 40 charts per day.

Please help.

 

[Andrew Poulsom]

Look here:

http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/