I have created a Pivot chart from said pivot table. I'd like to be able to use the trendline formula to calculate various values along the trendline, but am having trouble not ending up with #NA errors
I suspect it is in how I am defining the named range x and y. My basic formula for the power trendline is as follows:
Equation y=c*x^b
where
c: =EXP(INDEX(LINEST(LN
,LN(x),,),1,2))
x: is an input
b: =INDEX(LINEST(LN,LN(x),,),1)
I have defined x as the range of the values in the pivot table A5:A10
I have defined y as the range of the figures in column C5:C10
I would like to use the pivot Table as the data set so I can easily change parameters rather than the main data set.
I guess in the simplest terms I can think of, can you use the equation for the trendlines developed from a PivotChart in a formula elsewhere in a worksheet?
I suspect it is in how I am defining the named range x and y. My basic formula for the power trendline is as follows:
Equation y=c*x^b
where
c: =EXP(INDEX(LINEST(LN
,LN(x),,),1,2))x: is an input
b: =INDEX(LINEST(LN
,LN(x),,),1)I have defined x as the range of the values in the pivot table A5:A10
I have defined y as the range of the figures in column C5:C10
I would like to use the pivot Table as the data set so I can easily change parameters rather than the main data set.
I guess in the simplest terms I can think of, can you use the equation for the trendlines developed from a PivotChart in a formula elsewhere in a worksheet?
