Trendline Update

[Bill]

I'm using Excel 2000 (9.0.2720). I have a simple chart with a
trendline added. After I enter new data, does the trendline equation
automatically update, or do I have to perform an operation to get it
to update? Thanks!

Bill

 

[Jim Thomlinson]

Try it and see... I think you will find that it does update. You can also
create the formual yourself using the slope and intercept functions...

 

[Bill]

Thanks Jim, The slope is so subtle that I didn't notice!

Bill