Error Checking in Excel
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.

Some videos you may like

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
  •