Single click on the legend entry, then single click again (clicking on the
name, not the symbol). You can now press the delete key to remove the entry
from the legend.
Which version of Excel allows that, Luke? It doesn't look as if Excel 2003
does. It will do that for a normal series, but not for a trend line.
For a trend line, all I could think of was to change the colour of font and
background, but that would make invisible not just the word "Linear", but
also the "(Series 1)" or whatever (i.e. the series name of the series for
which the trend line is drawn).
Unfortunately, it didn't work. I just want to remove the TYPE of trend line
that it is (in my case the LOG for logarithmic) in the Legend not the actual
Legent entry. Thanks to you both for your help - any other ideas?
I suppose that one way would be to look at the equation of your trendline
(or use an appropriate regression process to produce the equivalent
equation), then produce a series using that equation, then plot that series
(with whatever label you want) and delete the trendline from your plot.
Format trendline. Under options tab, you can choose the automatice name
(include type) or give it your own name (even nothing, if you want it blank)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.