Trend Lines and the Legend

[Gingerly]

The type of trend line is displayed in the Legend. Is there any way to
delete that? Thanks.

 

[Luke M]

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.

 

[David Biddulph]

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).

 

[Luke M]

Hmm, I'm using XL 2003, SP3.

Are you sure you're selecting the Trendline Legend entry, and not the
Trendline Legend key?

Additionally, the trendline legend entry can be removed from the legend
similar to other series, using VB:

ActiveChart.Legend.LegendEntries(2).Delete

 

[Gingerly]

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?

 

[David Biddulph]

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.

 

[Luke M]

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)