RSQ, but exponential

I have no idea if this is possible.

I am trying to use the RSQ worksheet function, but having it measure with an exponential line of best fit. The worksheet function automatically uses a linear line of best fit but this is not what I am looking for. Our data is almost always exponential and we are trying to automate it, so if there is some command that finds R-squared with exponential, that would make our lives easier.

Thanks a lot.
Will

Can you create a dummy column with the exponential?

=EXP(A1)

where A1 is your y data point.

Then calculate RSQ using your x values and the new column.

ChemistB

That didn't do it. I am going to post this question in the charting area and try to frame it in that context. Thanks anyways though

I have a graph that we have run a best fit line for, which is exponential. We can have the graph give us the equation of the line along with the R-squared. Is there a way to get the R-squared in the worksheet itself? The RSQ command only does linear. It seems like since Excel generates the R-squared for the exponential, there must be a way to get it to show up in the cells.

Use the dummy column
=ln(A1)

where A1 is your x data point.

Then calculate RSQ using your x values and the new column.

Thanks gust 123, that worked! We made it so we were taking the natural log of the y value rather than the x value and it came out just as we had hoped.