Hi Dan,

Bernard has told you how to do what you asked for. Just a word of caution on
using polynomial regression.

I don't know what data you are trying to fit, but I usually discourage
people from using polynomial models unless they have a good reason to
suspect that the 'real life' data should fit a polynomial curve (e.g. a ball
thrown in the air).

If you are trying to fit business data, then polynomial curves are not very
useful IMO. Given a fixed number of data points, you can always find a
polynomial curve with exact fit just by adding enough coefficients. However,
this is not likely to be a good model for the underlying data.

If you have monthly data that may show a seasonal component and a trend,
then it may be better to try smoothing the data with a logarithmic filter
that does not remove too much of the underlying structure. You can download
a Henderson filter from
http://www.edferrero.com/ExcelCharts...2/Default.aspx

HTH

Ed Ferrero
www.edferrero.com