Here's a list of formulas that will generate trendlines:

http://j-walk.com/ss/excel/tips/tip101.htm

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

"kathy" wrote in message
...
I am having a dual problem:

1. On a scatter graph I can't get the trendline equation
to update when the trendline itself moves (ie I am using
the worksheet as a template for a complex calculation so
each time I do it, the data the trendline is based on has
been changed, the trendline moves but the equations stays
the same - I have to delete it and reapply it to get it
to update).

2. I am using the trendline equation to calculate values
for other points that lie on the trendline. To do this I
am using the formula for the trendline and want a way to
get it off the chart and into a cell without having to
type it in manually - I want the template essentially
totally automated to reduce human error.

Anyone got any ides?

Thanks heaps,
Kathy