Forum Discussion
Solved
exponential trend line
I am trying to match the exponential trendline formula returned from a line chart using LINEST. The x-axis values (column B) start from one which is what the line chart is supposed to do and the y-axis values are calculated using the LN function (column C). Besides that I don't know what else I need to do to match the trend line in the chart.
In the equation y = 1.7599e-0.273x, the 1.7599 is =EXP(F2)
Your LINEST formula produces the coefficients for the exponential trend line.
If you want the coefficients logarithmic trend line, you should use LN(x-values) instead of LN(y-values)
HansVogelaar it is the exponential trend line that I want. My problem is that I am not matching exactly to the coefficient values that the trend line on the line chart is showing
In the equation y = 1.7599e-0.273x, the 1.7599 is =EXP(F2)
