Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "thorgamma" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
One bar line with two trend lines | Charts and Charting in Excel | |||
Trend Lines help | Charts and Charting in Excel | |||
Trend Lines | Charts and Charting in Excel | |||
Charts recalculate to 100% | Charts and Charting in Excel | |||
Trend lines disappearing... | Charts and Charting in Excel |