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)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Phil Hageman" wrote in message
...
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

Thanks, it's on the way

"Bernard Liengme" wrote:

Are you using a dynamic chart? It should work. I would be happy to look at
file (send to me not list)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Phil Hageman" wrote in message
...
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

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.

"Bernard Liengme" wrote:

Are you using a dynamic chart? It should work. I would be happy to look at
file (send to me not list)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Phil Hageman" wrote in message
...
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

Hi Phil

Did you manage to sort this problem? I have recently started using Office
2007 and am finding the same problem. On some websites it suggests that it is
s bug in office 2007. Seems quite a large bug though!!

Thanks for any help

chris

"Phil Hageman" wrote:

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

L.S.

The only way to get around the problem is to remove the graph at every
modification and recalculate the trendline and equation. Quite basic but it
helps as long the real solution is not available!

Say CHEESE!

"chris" wrote:

Hi Phil

Did you manage to sort this problem? I have recently started using Office
2007 and am finding the same problem. On some websites it suggests that it is
s bug in office 2007. Seems quite a large bug though!!

Thanks for any help

chris

"Phil Hageman" wrote:

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