On Thu, 7 Sep 2006, in microsoft.public.excel.charting,
Ahab said:

A line of best fit is then drawn and the resulting graph used to obtain data
to put through some formulae. I can quite easily use Excel to plot an
appropriate chart and add a suitable trendline but I am at a loss as to how
to get excel to "read" data from that trendline.

As is so often the case, this is not really an appropriate thing to ask
the charting engine to do. Instead, try experimenting with the SLOPE()
and INTERCEPT() functions in the spreadsheet itself to get them to
calculate the figure you are looking for.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.