Trendline Textbox Not Updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After entering monthly data, the trendline (2nd order polynomial) updates,
but the textbox on the chart holding the equation and R-squared values does
not. What is the problem?
Thanks, Phil
 
Are you using a dynamic chart? It should work. I would be happy to look at
file (send to me not list)
 
I used to have the equation updating automaticly in a graph when changing the
source data. ( excel 2003 ).
Since I use excel 2007 this feature does not work unless I restart the whole
equation procedure. What do you mean with dynamic chart, how to make it
dynamic.

Thanks.
 
Back
Top