Hiding Chart Legend Entry
Hiding Chart Legend Entry
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Hiding Chart Legend Entry

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, Texas
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Anyone know how to prevent one of several chart series entries from showing up in the chart legend? I asked this previously on the old board and someone suggested replacing the the legend reference in the series formula with "" like this:

    =SERIES("",xSeriesRef,ySeriesRef,1)

    This only does half of what I want (it hides the text but leaves the symbol). I sometimes use SERIES formulas to draw reference lines through chart data points or construct custom gridlines (probability spaced, for example) & don't want a legend entry to show up for the reference series, but need to keep the legend entries for the data series.

    Thanks!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Delete it from the Legend box

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, Texas
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How? When I select a legend entry and delete it, the series it goes with also disappears from the plot.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Create a column chart using...

    {"","Jan","Feb","Mar"
    ;"Apples",10,30,50
    ;"Oranges",20,40,60
    ;"Lemons",30,50,70}

    Oranges are charted as Series 2. Click on "Oranges" in the Legend until selected. Press [ Delete ]. Notice the Series 2 column is still on chart, but "Oranges" no longer in the Legend.

    [ This Message was edited by: Mark W. on 2002-02-27 16:09 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, Texas
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Works great with a column chart. Unfortunately I'm using an XY scatter plot (Numeric X values vs. numeric Y values) & it refuses to cooperate.

  6. #6
    Guest

    Default

    Create an XY chart using...

    {"X","Y","Z"
    ;1,10,1
    ;2,20,3
    ;3,30,5}

    ...with series in colums. This will produce 2 series and 2 legend entries. As before select the "Y Legend Entry" (NOT the "Y Legend Key"; there's a difference) by clicking on the "Y" in the legend (NOT it's symbol) and press [ Delete ]. Notice the 1st series is still plotted after the removal of its legend entry.

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That was me above. Sometimes this bulletin board logs you off an the most inopportune times. Here's what I was trying to add...

    ...with series in columns. This will produce 2 series and 2 legend entries.

    As before select the "Y Legend Entry" (NOT the "Y Legend Key"; there's a difference) by clicking on the "Y" in the legend (NOT it's symbol) and press [ Delete ]. If you're in doubt about what's selected look at the Name box just left of the Formula Bar.

    Notice the 1st series is still plotted after the removal of its legend entry.

    [ This Message was edited by: Mark W. on 2002-02-27 16:59 ]

  8. #8
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, Texas
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Wonderful! Exactly what I wanted!

    I can't believe that such a simple distinction makes such a big difference.

    This site is great! Thank you.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com