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:
    335
    Gary Klass
    Dec 14, 2003
  2. Guest

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

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

    Extracting Constant from Non-linear Trend line

    tomsan82, Jun 16, 2006, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    239
    Tushar Mehta
    Jun 16, 2006
  4. 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:
    947
    FlexoC
    Aug 22, 2008
  5. wirepusher

    linear trend lines do not appear gaps in data

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

Share This Page