Trend lines on data subsets

Discussion in 'Excel Charting' started by eehi, Dec 25, 2012.

  1. eehi

    eehi Guest

    Hello

    How do I create trend lines on subsets of data in an Excel (Home and Busines
    2010) graph? I have data over dates ranging from 1976 through 2010, and I wan
    separate trend lines on the data from 1976-1990, from 1990-2005, and fro
    2005-2010, all without breaking up the single flow of data from '76-'10

    Also: Merry Christma

    Thank

    Eric Hines
     
    eehi, Dec 25, 2012
    #1
    1. Advertisements

  2. eehi

    Anatory Guest

    Adding trend lines to Excel charts can highlight significant changes i
    that involve times series plots with multiple trend lines on the sam
    data

    'doctors excuse' (http://domtomweb.com/


    --
    Anatory
     
    Anatory, Dec 26, 2012
    #2
    1. Advertisements

  3. eehi

    eehi Guest

    eehi wrote on 12/25/2012 10:37 ET
    > Hello
    >
    > How do I create trend lines on subsets of data in an Excel (Home and Busines
    > 2010) graph? I have data over dates ranging from 1976 through 2010, and

    wan
    > separate trend lines on the data from 1976-1990, from 1990-2005, and fro
    > 2005-2010, all without breaking up the single flow of data from '76-'10
    >
    > Also: Merry Christma
    >
    > Thank
    >
    > Eric Hine
    >

    Indeed. Which is why "I want separate trend lines on the data fro
    1976-1990, from 1990-2005, and from 2005-2010, all without breaking up th
    single flow of data from '76-'10.

    Any ideas on how to do that

    Thank

    Eric Hines
     
    eehi, Dec 26, 2012
    #3
    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. Nev.

    Trend Lines

    Nev., Oct 31, 2003, in forum: Excel Charting
    Replies:
    7
    Views:
    157
  2. Nev.

    Trend Lines Only?

    Nev., Oct 31, 2003, in forum: Excel Charting
    Replies:
    3
    Views:
    76
  3. bonzo

    linear trend lines

    bonzo, Dec 9, 2003, in forum: Excel Charting
    Replies:
    2
    Views:
    650
    Gary Klass
    Dec 14, 2003
  4. Tony Williams

    Trend Lines

    Tony Williams, Feb 8, 2004, in forum: Excel Charting
    Replies:
    5
    Views:
    88
    Jerry W. Lewis
    Feb 9, 2004
  5. Simon Russell

    Excel Chart with 2 bars and 2 trend lines

    Simon Russell, Aug 11, 2004, in forum: Excel Charting
    Replies:
    1
    Views:
    127
    Jon Peltier
    Aug 11, 2004
  6. akh2103
    Replies:
    2
    Views:
    115
    Del Cotter
    Jun 14, 2007
  7. wirepusher

    linear trend lines do not appear gaps in data

    wirepusher, Apr 23, 2009, in forum: Excel Charting
    Replies:
    1
    Views:
    95
    Andy Pope
    Apr 23, 2009
  8. Ed
    Replies:
    1
    Views:
    143
    Jon Peltier
    Sep 10, 2010
Loading...