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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.