#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Trendline Update

I'm using Excel 2000 (9.0.2720). I have a simple chart with a
trendline added. After I enter new data, does the trendline equation
automatically update, or do I have to perform an operation to get it
to update? Thanks!

Bill
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Trendline Update

Try it and see... I think you will find that it does update. You can also
create the formual yourself using the slope and intercept functions...
--
HTH...

Jim Thomlinson


"Bill" wrote:

I'm using Excel 2000 (9.0.2720). I have a simple chart with a
trendline added. After I enter new data, does the trendline equation
automatically update, or do I have to perform an operation to get it
to update? Thanks!

Bill
.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Trendline Update

Thanks Jim, The slope is so subtle that I didn't notice!

Bill

On Fri, 18 Dec 2009 14:22:01 -0800, Jim Thomlinson
wrote:

Try it and see... I think you will find that it does update. You can also
create the formual yourself using the slope and intercept functions...

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
Update one worksheet tab to automatically update all other tabs? shoechic1 Excel Worksheet Functions 1 May 24th 09 03:55 PM
Data Validation lists update orginal cell with list update [email protected] Excel Worksheet Functions 3 July 11th 08 07:56 AM
i want to update one excel file the other one update automaticaly Basant New Users to Excel 1 December 16th 06 12:50 AM
trendline YK Charts and Charting in Excel 1 September 14th 06 11:06 PM
Trendline Trend Excel Worksheet Functions 1 April 25th 06 12:20 AM


All times are GMT +1. The time now is 04:30 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"