[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
