Trendline Values

  • Thread starter Thread starter Kristin
  • Start date Start date
K

Kristin

How do you display the values of a trendline on your
chart? I used the add trendline feature within the chart
and would like to see the exact values it plotted -- the
only items I can view are the R-squared and the equation,
but no values.

Thanks!
 
[This followup was posted to microsoft.public.excel.charting with an
email copy to Kristin.
Please use the newsgroup for further discussion.]

There's no easy way to get what you want from the trendline data. If
the relationship is linear (i.e., y=a*x+b), it would be a lot simpler
to use the TREND worksheet function. Suppose the X values are in
A6:A16 and the Y values in B6:B16. Then, select C6:C16 and array-enter
=TREND(B6:B16,A6:A16,A6:A16,TRUE)

If the relationship is exponential, check the GROWTH function in XL
help. If the relationship is polynomial, it is possible to get the
results with the help of the LINEST function. Post back and you should
get a response from, if not me, then someone else.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site
--
An array formula is entered with CTRL-SHIFT-ENTER rather than just
ENTER. If done correctly, XL will display curly brackets { and }
around the formula

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top