Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default excel 2007 trendline equation

I'm used to see t trendline updating automatically when the source data change.
Now this does not work any more.
In the Q&A I read bout dynamic charts what does that mean ?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default excel 2007 trendline equation

Hi Erwin,

I can't duplicate your problem. If my data changes the associated trendline
changes. Are you adding the trendline via the Chart Tools, Layout command?
Is Recalculation set to Automatic?
--
Cheers,
Shane Devenshire


"Erwin_Goethals" wrote:

I'm used to see t trendline updating automatically when the source data change.
Now this does not work any more.
In the Q&A I read bout dynamic charts what does that mean ?

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default excel 2007 trendline equation

Hello,

Taking a working worksheet from my computer running excel 2003 and opening
it on my excel 2007 , I notice the trendline equation is not updated any more.
I have to delete the trendline and make a new one in order to get a correct
equation.
The way I add a trendline is by selecting the basic graph and select add
trendline.
My worksheets are standard in automatic recalculation, so still no solution.
If needed I can sent the two versions.
Thanks.
"ShaneDevenshire" wrote:

Hi Erwin,

I can't duplicate your problem. If my data changes the associated trendline
changes. Are you adding the trendline via the Chart Tools, Layout command?
Is Recalculation set to Automatic?
--
Cheers,
Shane Devenshire


"Erwin_Goethals" wrote:

I'm used to see t trendline updating automatically when the source data change.
Now this does not work any more.
In the Q&A I read bout dynamic charts what does that mean ?

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
Trendline Equation error Excel 2007? SPWelch Charts and Charting in Excel 3 June 18th 07 11:08 AM
trendline equation terry Charts and Charting in Excel 6 December 19th 06 08:56 PM
Trendline Equation bastien86 Excel Worksheet Functions 5 July 8th 06 03:19 AM
Excel graphed trendline does not match derived equation Keith Charts and Charting in Excel 5 March 13th 06 08:15 PM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM


All times are GMT +1. The time now is 06:32 PM.

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

About Us

"It's about Microsoft Excel"