ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   FIGURING OUT DATAPOINTS FROM TRENDLINE (https://www.excelbanter.com/charts-charting-excel/238802-figuring-out-datapoints-trendline.html)

Bri123321

FIGURING OUT DATAPOINTS FROM TRENDLINE
 
Trying to figure out how to pull data points from a trendline

Bernard Liengme[_3_]

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




John Mansfield

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



All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com