Extracting Data points from trendline

**jsuarez199** · 10-24-2013, 03:39 AM

Hi Guys,

I have a graph with a logarithmic trendline, and I need to show the data points for it in two excel columns (x,y). This needs to be done automatically so that when I change the points and the trendline shifts, the data points on my two columns will be automatically updated. Does anyone know how to do this? thanks!

**zbor** · 10-24-2013, 04:08 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**jsuarez199** · 10-24-2013, 08:06 AM

Thanks ZBOR,

Here you go!

**jsuarez199** · 10-25-2013, 05:14 AM

Any luck? :S

**MrShorty** · 10-25-2013, 10:21 AM

The first thing I would suggest: learn how to use the LINEST() function to perform these regressions: http://office.microsoft.com/en-us/ex...in=HA010277524 Using the LINEST() function will allow you to perform the regression directly in the worksheet and eliminate the need to copy the equation from the chart to the spreadsheet.

Using the LINEST() function, you can either perform the regression in the source files and link that to this file or in this destination file, I'm not sure that it matters. I would probably also pull into this file the max(tenor) from each source file. From there, it should be easy enough to build a formula for Tenor and yield that will take into account the max tenor from the original source file.