Allowable trendlines
Allowable trendlines
(OP)
I have about 8 pairs of x,y data I want to fit a trendline to. The options available though are only for linear, polynomial, exponential, and moving average. The power and logarithmic options are greyed out. Why should that be?
corus





RE: Allowable trendlines
Try using the LINEST() or LOGEST() functions directly on the underlying data rather than the trendline feature of charts. Excel's help sort of explains how to use LINEST to achieve higher order polynomial fits.
Both functions are array functions.
RE: Allowable trendlines
Try shifting the data by a constant(C) so the lowest data point is +1. Then, the plotted log function is y = m Log(x+C)+b and plotted power function is Log(y+C1)= m Log(x+C2)+b
Or, if an entire series is negative, multiply by -1 so the plotted log function is y = m Log(-x)+b and plotted power function is Log(-y) = m Log(-x)+b
RE: Allowable trendlines
corus