Trendline Textbox Not Updating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Hageman - 05 Jul 2005 15:03 GMT

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

Reply to this Message

Bernard Liengme - 05 Jul 2005 15:31 GMT

Are you using a dynamic chart? It should work. I would be happy to look at
file (send to me not list)

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> 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

Reply to this Message

Phil Hageman - 05 Jul 2005 16:55 GMT

Thanks, it's on the way

> Are you using a dynamic chart? It should work. I would be happy to look at
> file (send to me not list)
[quoted text clipped - 3 lines]
> > not. What is the problem?
> > Thanks, Phil

Reply to this Message

Erwin_Goethals - 11 May 2008 16:09 GMT

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.

> Are you using a dynamic chart? It should work. I would be happy to look at
> file (send to me not list)
[quoted text clipped - 3 lines]
> > not. What is the problem?
> > Thanks, Phil

Reply to this Message