Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to recalculate trend lines in Excel charts?
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
|
|||
|
|||
Is there a way to recalculate trend lines in Excel charts?
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 | |
|
|
Similar Threads | ||||
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 |