Is there a way to recalculate trend lines in Excel charts?

T

thorgamma

If the underlying data changes, a trend line on a chart does not
automatically update, nor can I find a command to cause it to update. Is
there a way?
 
B

Bernard Liengme

That should not be: if there is a change in the data, the trendline equation
should update.
If using XL2003 use Tools | Options and open Calculation tab and make sure
Calculations is set to automatic. Very similar in Excel 2007 (Office button
| Excel Options.....)
If this does not solve the problem please reply to this message
best wishes
 

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

Correct process for creating a linear trend line in Excel 26
Export BPMN Visio Chart to Excel 0
Creating Network Diagram using a Chart SW integration 0
Excel IMPORT which updates fields 0
Setting column width in a table with a macro is not working 0
Auto-Numbering in a Table in MS Word 1
Missing data when using TREND function 0
Possible to Combine reports to's to a single box? 0

Top