Fitting a power or exponential trendline

[Daniel]

How do I fit a power or exponential trendline to a data
series in a chart? I only have the options of linear and
polynomial trendlines.

 

[Arto Huttunen]

How do I fit a power or exponential trendline to a data
series in a chart? I only have the options of linear and
polynomial trendlines.

Y = exp( a * X) ===> log(Y) = a * X

 

[Jerry W. Lewis]

Chart|Add Trendline and select the type of model that you want.

Jerry

 

[Michael R Middleton]

Daniel -

How do I fit a power or exponential trendline to a data series in a chart?

I only have the options of linear and polynomial trendlines. <

Excel uses transformations to fit power and exponential, and if the original
data has negative values those options are greyed out.

A workaround is to add a constant to the original data so that all values
are positive.

- Mike Middleton, www.usfca.edu/~middleton