"joeu2004" wrote...
On Jul 7, 8:02 pm, raymondvillain
I have made a graph of my data and used the "trend" feature of Excel 2007
to
add a polynomial trend line to the graph. I need to use the coefficients
in
subsequent calculations. It is tedious to type them into cells manually.
Is
there not a way to have Excel automatically enter them into a cell,
without
using LINEST() or TREND()?

Why not use LINEST()? See the bottom of
....

LINEST doesn't always provide the same result as chart trend lines. Prior to
Excel 2007, the numeric programming behind chart trendlines was superior to
that behind LINEST. I've seen postings that this may have been reversed in
Excel 2007, so OP may be better off using LINEST even if it does give
different results than chart trendlines.

But FTHOI, see

http://groups.google.com/group/micro...440d271303e0d6