I am trying to calculate a curve fit using the LOGEST function

I have edited this as follows:
this is not a charting question - it was poorly worded by me. My question is: "how to calculate the x,y pairs for the fitted curve"
Joe Miller
-----------------------------------------

I am trying to calculate a curve fit using the LOGEST function, as shown on the attachment.

I want to then plot the fitted curve on the chart but have not been able to figure out how to calculate the x,y pairs for the fitted curve.

The 6 data points which are to be fitted are plotted on the graph.

The LOGEST formula is entered in cell A9.

In C2 and copy down

=$B$9 * $A$9 ^ A2

If you right-click the plotted series and add an exponential trendline, you'll see that the results above fall on it.

You can regress anything to a polynomial of sufficiently high order, Joe, but there is not much common data that is polynomial in behavior.

Select A23:C23 and array-enter this:

=LINEST(B2:B21, A2:A21^{1,2})

Then in C2 and copy down, =SERIESSUM(A2, 2, -1, $A$23:$B$23) + $C$23

SERIESSUM is a bit of overkill for a quadratic, but it's compact for higher-order polynomials.

You're welcome. Mark us up as solved, Joe?