Trending in a chart

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I've got a line chart and have created two trends:
logarithmic and polynomial. I see both lines on the
graph but in trying to determine which is the best
trendline I'm trying to find the actual 'y' values for
the trendlines. I've searched help extensively and can't
seem to find the formula Excel uses. Can anyone provide
help on how to find the actual values behind the
trendlines? I would greatly appreciate it. Thank you.

Andy
 
Double-click each trendline and in the resulting dialog box from the
Options tab check the 'Display equation on chart' and 'Display R-squared
value on chart'.

Then, double-click each equation displayed and from the Number tab
select the Number format and finally from the Decimal Places select an
appropriately large number of decimal places.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004
 
Or use TREND()
=TREND(yRange,xRange^{1,2,3})
gives the cubic trendline, and
=TREND(yRange,LN(xRange))
gives the logarithmic trendline. Of course both are array formulas
(Ctrl-Shift-Enter)

Jerry
 
Back
Top