Trendline Textbox Not Updating

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
 
B

Bernard Liengme

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

Erwin_Goethals

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ploynomial Trendline Equation Changes After Copy Paste 11
using polynomial trendline equations 2
how do i extract the formula from a trendline in Excel? 1
extracting data touching trendline 3
Excel 2007 Polynomial Order Incorrect 7
Trendline equation calculation 3
Trendline values 2
EXCEL polynomial trendlines 1

Top