Creating a linear trend line in Excel

Discussion in 'Microsoft Excel Charting' started by Onion Knight, Jun 15, 2012.

  1. Onion Knight

    Onion Knight Guest

    There has been some debate in COLA as to the correct way to create a
    linear trendline in Excel. Someone in the forum kindly made a video to
    show what he thought was the correct method
    http://tmp.gallopinginsanity.com/LinearTrendLineCreation.mov

    A couple of other people in the group say that the video skips a
    number of steps but when I look at the directions from Microsoft I do
    not see any they could be referring to.

    Does anyone see any missing steps for the creation of a linear trend
    line? I admit this is a bit over my head so any input would be welcome.
     
    Onion Knight, Jun 15, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. bonzo

    linear trend lines

    bonzo, Dec 9, 2003, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    424
    Gary Klass
    Dec 14, 2003
  2. Guest

    how to draw a line chart from a linear equation?

    Guest, Sep 20, 2004, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    341
    Bernard Liengme
    Sep 20, 2004
  3. Guest
    Replies:
    2
    Views:
    384
    Jerry W. Lewis
    Oct 1, 2005
  4. Guest

    How do I anchor one end of a linear trend line?

    Guest, Jan 14, 2006, in forum: Microsoft Excel Charting
    Replies:
    3
    Views:
    1,251
    Guest
    Jan 15, 2006
  5. tomsan82

    Extracting Constant from Non-linear Trend line

    tomsan82, Jun 16, 2006, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    306
    Tushar Mehta
    Jun 16, 2006
  6. FlexoC

    How do I set a Trend Line and Remove the Data Line

    FlexoC, Aug 22, 2008, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    1,894
    FlexoC
    Aug 22, 2008
  7. keith

    Problem creating a logarithmic trend line

    keith, Apr 8, 2009, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    3,058
    keith
    Apr 8, 2009
  8. wirepusher

    linear trend lines do not appear gaps in data

    wirepusher, Apr 23, 2009, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    430
    Andy Pope
    Apr 23, 2009
Loading...