trendline equations
 

Can add a trendline to a graph and create a polynomial equation and display
this information on the graph. I need this information in a worksheet
cell(s). Having to copy and paste the information when there are several
charts and several analysis going on is very cumbersome.

Hi,

Check out this explanation of the formula needed LINEST
http://www.stfx.ca/people/blie ngme/ExcelTips/Polynomial.htm

Cheers
Andy

Nick wrote:
Can add a trendline to a graph and create a polynomial equation and display
this information on the graph. I need this information in a worksheet
cell(s). Having to copy and paste the information when there are several
charts and several analysis going on is very cumbersome.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy,

Thanks for the info. Will run this and see how it goes.

Nick


"Andy Pope" wrote:

Hi,

Check out this explanation of the formula needed LINEST
http://www.stfx.ca/people/blie ngme/ExcelTips/Polynomial.htm

Cheers
Andy

Nick wrote:
Can add a trendline to a graph and create a polynomial equation and display
this information on the graph. I need this information in a worksheet
cell(s). Having to copy and paste the information when there are several
charts and several analysis going on is very cumbersome.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info