Trend Lines and the Legend

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

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.

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.

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.

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.

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.

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

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


"Gingerly" wrote:

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.