Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default FIGURING OUT DATAPOINTS FROM TRENDLINE

Trying to figure out how to pull data points from a trendline
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default FIGURING OUT DATAPOINTS FROM TRENDLINE

Tell us what trendline you are using: linear, polynomial ....?
You need to use a formula to get the trendline equation values into cells
You may be be able to use the TREND function
Please tell us more and we can help you
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Bri123321" wrote in message
...
Trying to figure out how to pull data points from a trendline



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 235
Default FIGURING OUT DATAPOINTS FROM TRENDLINE

The Spreadsheet Page provides the formulas used to create the trendlines.
You might be able to apply these formulas to your data to calculate the
values.

http://spreadsheetpage.com/index.php...line_formulas/

--
John Mansfield
http://www.cellmatrix.net


"Bri123321" wrote:

Trying to figure out how to pull data points from a 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
Excel 2007 does not take more than 255 datapoints adamsk Charts and Charting in Excel 2 October 8th 07 02:29 PM
intergrate a curve of datapoints LHM Excel Discussion (Misc queries) 1 February 14th 07 11:20 AM
Help with datapoints stack in XYScatter PO Charts and Charting in Excel 1 May 14th 06 11:43 PM
Datapoints Dondi Charts and Charting in Excel 1 March 8th 06 05:31 PM
Specific datapoints selection Metin Charts and Charting in Excel 7 February 19th 05 04:59 AM


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