P
Phil Hageman
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.
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.