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.
--
David Biddulph

"Gingerly" wrote in message
...
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?

"Luke M" wrote:

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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"David Biddulph" wrote:

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

"Luke M" wrote in message
...
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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gingerly" wrote:

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