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!
=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!