Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Excel 2002 (Trendline - Line & Symbol in Legend)

    Hi,
    A colleague of mine has a graph that has a symbol that plots the data points in a graph... this symbol appears in the legend. Then she created a trendline off of the same data points, which created a straight-dotted line... we can not figure a way to get this straight-dotted line to ALSO appear in the legend along with the symbol. We want the symbol AND the line to show up in the legend so that readers of the graph understand which trendline belongs with which data point symbol. Different colors are NOT an option with this graph as it will ultimately be published in black & white. Any help is always appreciated!!
    Thanks!
    Lana

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2002 (Trendline - Line & Symbol in Legend)

    As far as I know that is not possible.

    As an alternative, you could calculate the values for the trend line using the TREND function, then add the trend line as a new series. You can format the series just like you can format any other series. But, as a consequence, the trend line itself will also have markers for the data points.
    See the attached workbook.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Excel 2002 (Trendline - Line & Symbol in Legend)

    We'll give that a try... thanks Hans!
    Lana

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel 2002 (Trendline - Line & Symbol in Legend)

    Another option is to add a Dummy range (I used an NA so it would not plot) and format it with the label and line combo desired. Then you can remove the legends fo the actual series and and the trendline:

    select each individually in the legend (both the marker and name should be selected)
    <Delete>


    See the attached file (modifed from Hans' sample)
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •