|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 3rd, 2009, 08:58 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
FIGURING OUT DATAPOINTS FROM TRENDLINE
Trying to figure out how to pull data points from a trendline
|
|
#2
August 4th, 2009, 01:34 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
August 8th, 2009, 02:12 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
