+ Reply to Thread
Results 1 to 3 of 3

Copy coefficients of an equation produced by a graph into cells

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    London
    MS-Off Ver
    Excel 2011 Mac
    Posts
    2

    Question Copy coefficients of an equation produced by a graph into cells

    Hi there,
    I was just wondering when you place a trendline on a graph and choose to have the equation of said trendline displayed, is there anyway of copying the coefficients of each term into cells automatically?

    For example if the equation was y = 3x^3 + 2.5x^2 + x + 3.6

    It would read:

    A1: 3
    A2: 2.5
    A3: 1
    A4: 3.6

    Any help would be much appreciated!

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Copy coefficients of an equation produced by a graph into cells

    The standard approach is to fit the data from which the graph was generated.

    See:

    http://spreadsheetpage.com/index.php...line_formulas/

    or

    http://www.tushar-mehta.com/publish_...nalysis/16.htm
    Gary's Student

  3. #3
    Registered User
    Join Date
    03-06-2013
    Location
    London
    MS-Off Ver
    Excel 2011 Mac
    Posts
    2

    Re: Copy coefficients of an equation produced by a graph into cells

    Amazing, thank you!! You have no idea how much time that has just saved me!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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