| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How generate trendline equations for Power, Exp and Log trendlines | Excel Worksheet Functions | |||
| Trendline Extract | Charts and Charting in Excel | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Rounding in Trendline Equation | Charts and Charting in Excel | |||
| How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
Linear Mode
