Hiding Chart Legend Entry

[Matanuska]

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!

[Mark W.]

Delete it from the Legend box

[Matanuska]

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

[Mark W.]

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 ]

[Matanuska]

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.

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.

[Mark W.]

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 ]

[Matanuska]

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.