Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default How to Automate Copying of trendline equation to a cell

I want to figure out have excel take an equation for a trendline out of a
chart and paste it into a set of cells to calculate new values.

For example I have data at time 100, 200, 300 and 500, but want to
automatically have the equation of the trendline fitting my data copy over to
a set of cells where the intermadiate data for time 25,50,75 etc will be
calculated.
I typically fit a polonomial trendline?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default How to Automate Copying of trendline equation to a cell

Polynomial, non-linear, Trendline Coefficients
and Regression Analysis

http://www.tushar-mehta.com/excel/ti...efficients.htm
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Kmartin" wrote in message
...
I want to figure out have excel take an equation for a trendline out of a
chart and paste it into a set of cells to calculate new values.

For example I have data at time 100, 200, 300 and 500, but want to
automatically have the equation of the trendline fitting my data copy over
to
a set of cells where the intermadiate data for time 25,50,75 etc will be
calculated.
I typically fit a polonomial trendline?



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
How to link trendline equation in graph to cell? rossgus Excel Discussion (Misc queries) 2 May 11th 08 03:41 PM
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
Rounding in Trendline Equation Phil Hageman Charts and Charting in Excel 3 January 15th 05 01:15 AM
Logarithmic Trendline Equation Phil Hageman Charts and Charting in Excel 2 January 13th 05 11:55 AM


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