| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting values from a trend line
I've got a line with 52 data points for which I've put in a Polynomial Trend
Line degree 6 to provide a smooth profile. The next stage that I want to do is to work out what the values are of the Trend Line. Currently I display the equation on the Chart, copy it, paste into a cell and adjust the format accordingly. Very long-winded, and the process needs to be re-done every time the data is updated. There must be an easier way. Something that involves a direct link and no copy and pasting. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trend line in Excel | Excel Discussion (Misc queries) | |||
| Line chart even though values missing | Charts and Charting in Excel | |||
| line graph-need to pick up dates as values for the x axis? | Charts and Charting in Excel | |||
| overcoming zero values in line graph | Charts and Charting in Excel | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Threaded Mode
