View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
GJS001 GJS001 is offline
external usenet poster
 
Posts: 9
Default Edit legend entry for a trendline

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.