Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Martinaire
 
Posts: n/a
Default Trend Lines (or Linest?)

Having calculated a Trend Line how do I get the trend line data back into a
spreadsheet from the chart. ie I've calculated sales over 12 months, then
calculated the trend but I want the actual trend data in a spreadsheet as
well as the original data.
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

If linear, use SLOPE & INTERCEPT functions
For polynomials, et use LINEST as in
=LINEST(B1:B10,A1:A10^{1,2,3}), =LINEST(A1:A10, LOG(B1:B10)), etc
see my website

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Martinaire" wrote in message
...
Having calculated a Trend Line how do I get the trend line data back into
a
spreadsheet from the chart. ie I've calculated sales over 12 months, then
calculated the trend but I want the actual trend data in a spreadsheet as
well as the original data.



  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Martinaire" wrote...
Having calculated a Trend Line how do I get the trend line data back into
a spreadsheet from the chart. ie I've calculated sales over 12 months,
then calculated the trend but I want the actual trend data in a
spreadsheet as well as the original data.


See

http://google.com/groups?selm=dbrade....microsoft.com

Or if that url wraps, try

http://makeashorterlink.com/?F699210D5


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
Excel Connector Lines JeffinDallas Charts and Charting in Excel 0 January 10th 05 06:01 PM
How to force continuous lines in line charts wal50 Charts and Charting in Excel 1 December 21st 04 11:43 PM
Shade alternate lines wyattf Excel Discussion (Misc queries) 3 December 16th 04 08:03 PM
Clean lines Gfhcouriers Charts and Charting in Excel 1 December 10th 04 12:09 PM
Bold Grid Lines Ctunes Excel Discussion (Misc queries) 1 December 8th 04 10:00 PM


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