| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Locating Trendline Equation Factors in Cells
When adding a trendline on a chart, one option is to add the trendline
equation to the chart. Is there a way to also populate off-chart cells with the various factors of the equation? For example: the equation on a chart is: y = 5.1460E+05Ln(x) - 2.5051E+06. The 5.1460E+05Ln(x) value would be found in cell A1, and the €“2.5051E+06 value in cell A2. As values are added to the data matrix and the equation changes, the cell values would change accordingly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help adding text values | Excel Worksheet Functions | |||
| Rounding in Trendline Equation | Charts and Charting in Excel | |||
| Logarithmic Trendline Equation | Charts and Charting in Excel | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
Threaded Mode
