Hi Kathy,
The behaviour you describe in 1 is very odd. The equation is linked to the
trendline and both are dynamic - change the data and the trendline and its
equation both alter. Does this happen even if you do not save the workbook
as a template? I cannot reproduce this in Excel 2002 or Excel 2003 Beta.

The answer to 2 is not so hard. Is it a linear trendline? If so you the
SLOPE and INTERCEPT functions. If it is polynomial (or linear with fixed
intercept) use LINEST. See www.stfx.ca/people/bliengme/Excelips on using
LINEST to fit a polynomial. There is also LOGEST for exponential fitting.
Tell us what type you are using.

Best wishes
Bernard


"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