View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Edit legend entry for a trendline

No option for what? The technique Luke described does what it sounds like
you're asking.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"GJS001" wrote in message
...
Duh... I had even used a Custom Trendline name earlier. My memory is not
what it used to be.

I was frustrated with trying to enter custom names for data series legend
entries without renaming the series itself. There seems to be no option
for
this.



"Luke M" wrote:

Go to Chart - Add Trendline. Click the Options tab. You can then input a
custom name for your trendline.
Or if you've already added it, double click on line, go to Options tab.
--
Best Regards,

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


"GJS001" wrote:

Is there a way to edit the legend text for a trendline?

Or is the only option to:

1. delete the tendline legend entry
2. create a "dummy" data series to add the legend item
3. remove the marker and line from the "dummy" series, so only the
title
remains.