remove "linear" from trendline legend entry

Discussion in 'Excel Charting' started by dschneiderch, Dec 19, 2011.

  1. dschneiderch

    dschneiderch Guest

    Hi, I am plotting some data but I only want to show the trends so
    I've hidden all the scatter points and am showing just the linear
    trendlines. However, the legend entries are Linear (April), Linear
    (May) etc...is there any way to just show the series names without
    "Linear"?
    Thanks.
     
    dschneiderch, Dec 19, 2011
    #1
    1. Advertisements

  2. dschneiderch

    Jim Cone Guest

    Right-click the trendline.
    In the pop-up menu choose Format Trendline.
    In the dialog box that appears, choose the Options tab.
    Under Trendline name, select Custom and fill in the new name.
    --
    Jim Cone
    Portland, Oregon USA .
    http://www.contextures.com/excel-sort-addin.html .
    (editorial review of special sort excel add-in (30 ways to sort)



    "dschneiderch" <>
    wrote in message
    news:...
    > Hi, I am plotting some data but I only want to show the trends so
    > I've hidden all the scatter points and am showing just the linear
    > trendlines. However, the legend entries are Linear (April), Linear
    > (May) etc...is there any way to just show the series names without
    > "Linear"?
    > Thanks.
     
    Jim Cone, Dec 19, 2011
    #2
    1. Advertisements

  3. dschneiderch

    Guest

    Pada Selasa, 20 Desember 2011 0:23:01 UTC+7, dschneiderch menulis:
    > Hi, I am plotting some data but I only want to show the trends so
    >
    > I've hidden all the scatter points and am showing just the linear
    >
    > trendlines. However, the legend entries are Linear (April), Linear
    >
    > (May) etc...is there any way to just show the series names without
    >
    > "Linear"?
    >
    > Thanks.


    klik this link; http://www.mathworks.com/help/matlab/data_analysis/detrending-data.html

    i think that is very easy to understand trend of data
     
    , Nov 27, 2013
    #3
    1. Advertisements

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.
Similar Threads
  1. Jo

    linear trendline

    Jo, Jul 29, 2003, in forum: Excel Charting
    Replies:
    0
    Views:
    159
  2. Bernard Liengme

    Excel: Can I force a linear trendline through the origin?

    Bernard Liengme, Sep 28, 2005, in forum: Excel Charting
    Replies:
    3
    Views:
    217
    B. R.Ramachandran
    Oct 3, 2005
  3. QuestGAV

    Linear Trendline Equation Question

    QuestGAV, Oct 10, 2005, in forum: Excel Charting
    Replies:
    2
    Views:
    700
    QuestGAV
    Oct 11, 2005
  4. Jan M.

    Linear trendline:wrong equation

    Jan M., Apr 28, 2006, in forum: Excel Charting
    Replies:
    11
    Views:
    165
    Jon Peltier
    May 1, 2006
  5. maperalia

    Linear Trendline

    maperalia, May 4, 2006, in forum: Excel Charting
    Replies:
    5
    Views:
    75
    maperalia
    May 4, 2006
  6. Douglas Eckert

    Linear Trendline Vs Common Sense

    Douglas Eckert, Jun 7, 2007, in forum: Excel Charting
    Replies:
    6
    Views:
    138
    Douglas Eckert
    Jun 8, 2007
  7. Rashid Sohail

    Trendline - Linear

    Rashid Sohail, Feb 27, 2008, in forum: Excel Charting
    Replies:
    1
    Views:
    95
    Jon Peltier
    Feb 28, 2008
  8. GJS001

    Edit legend entry for a trendline

    GJS001, Dec 15, 2008, in forum: Excel Charting
    Replies:
    6
    Views:
    210
    Jon Peltier
    Dec 16, 2008
Loading...