Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,104
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
One bar line with two trend lines Atwork today Charts and Charting in Excel 1 July 17th 08 10:15 PM
Trend Lines help Bob Charts and Charting in Excel 1 February 28th 08 10:29 AM
Trend Lines PA Charts and Charting in Excel 1 December 12th 07 03:14 PM
Charts recalculate to 100% tshad[_2_] Charts and Charting in Excel 4 September 28th 07 07:01 PM
Trend lines disappearing... Brisbane Rob Charts and Charting in Excel 0 July 13th 06 10:57 AM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"