+ Reply to Thread
Results 1 to 2 of 2

Use Tradline Equation From Graph

  1. #1
    Registered User
    Join Date
    02-01-2012
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    65

    Use Tradline Equation From Graph

    Is there a way to link a cell to the treadline equation in a graph. I want to predict future values based on the current data I have using the treadline formula. However, I will continually be updating the information in the graph to make it more accurate and wanted to know if there is a way to link that to a cell.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Use Tradline Equation From Graph

    I'm not aware of anyway to link the trendline coefficients from a graph to spreadsheet cell. However, you can use the LINEST function in the spreadsheet to create the trendline coefficients directly in the spreadsheet where you can use them in your analysis.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1