Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 9
Default Edit legend entry for a trendline

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.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Edit legend entry for a trendline

Yes, there is a way to edit the legend text for a trendline in Microsoft Excel. Here's how you can do it:
  1. Click on the chart to select it.
  2. Click on the trendline to select it.
  3. Right-click on the trendline and select "Format Trendline" from the context menu.
  4. In the "Format Trendline" pane that appears on the right-hand side of the screen, click on the "Options" tab.
  5. In the "Options" tab, you will see a field labeled "Custom Name". This is where you can edit the legend text for the trendline.
  6. Simply type in the new legend text that you want to use for the trendline in the
    Code:
    "Custom Name"
    field.
  7. Press "Enter" or click outside of the
    Code:
    "Custom Name"
    field to apply the new legend text to the trendline.

That's it! You have now edited the legend text for the trendline in your Excel chart without having to delete the trendline legend entry or create a "dummy" data series.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,722
Default Edit legend entry for a trendline

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.

  #4   Report Post  
Posted to microsoft.public.excel.charting
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.

  #5   Report Post  
Posted to microsoft.public.excel.charting
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.





  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 9
Default Edit legend entry for a trendline

Sorry - that was poorly worded. I have gone slightly off-topic by now
wanting to change the legend entry for scatter plot series.

I would like to double-click on the legend entry (or right click and Format)
as I do on axis titles, etc. to enter new or different text, regardless of
whether it is a trendline or scatter plot data. Right now, the only way to
change the legend entry for scatter plot data is to change the series name.
However, there are many instances where I don't want to change the series
name (such as I have many series on a single chart, and identify them by the
series name, but only want a single legend entry to represent all of them).

If there is a way of changing the legend entry for a data series, I am
unaware of it.


"Jon Peltier" wrote:

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.




  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 762
Default Edit legend entry for a trendline

GJS001 -

In Excel 2003 and earlier, right-click the trendline and from the shortcut
menu choose Format Trendline. Or, select the trendline, and choose Format |
Selected Trendline. In the Format Trendline dialog box, on the Options tab,
in the "Trendline name" section, click Custom and type a name. Click OK.

In Excel 2007, select the trendline (if necessary, using the Up Arrow and
Down Arrow to cycle through the major chart objects), and choose (Chart
Tools) Format | (Current Selection) Format Selection. In the Format
Trendline dialog box, on the Trendline Options tab, ...

- Mike Middleton
http://www.MikeMiddleton.com
Software and Books for Business Analytics



"GJS001" wrote in message
...
Sorry - that was poorly worded. I have gone slightly off-topic by now
wanting to change the legend entry for scatter plot series.

I would like to double-click on the legend entry (or right click and
Format)
as I do on axis titles, etc. to enter new or different text, regardless of
whether it is a trendline or scatter plot data. Right now, the only way
to
change the legend entry for scatter plot data is to change the series
name.
However, there are many instances where I don't want to change the series
name (such as I have many series on a single chart, and identify them by
the
series name, but only want a single legend entry to represent all of
them).

If there is a way of changing the legend entry for a data series, I am
unaware of it.


"Jon Peltier" wrote:

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.






  #8   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Edit legend entry for a trendline

A legend shows the series name in a legend entry. Period.

To display fewer legend entries than the chart would show by default, click
once on the legend, then once on an extraneous legend entry, then press
Delete. To get any deleted legend entries back, you have to delete the
legend and add it back, with all legend entries.

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


"GJS001" wrote in message
...
Sorry - that was poorly worded. I have gone slightly off-topic by now
wanting to change the legend entry for scatter plot series.

I would like to double-click on the legend entry (or right click and
Format)
as I do on axis titles, etc. to enter new or different text, regardless of
whether it is a trendline or scatter plot data. Right now, the only way
to
change the legend entry for scatter plot data is to change the series
name.
However, there are many instances where I don't want to change the series
name (such as I have many series on a single chart, and identify them by
the
series name, but only want a single legend entry to represent all of
them).

If there is a way of changing the legend entry for a data series, I am
unaware of it.


"Jon Peltier" wrote:

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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing trendline from legend Hosley Excel Discussion (Misc queries) 5 April 2nd 23 07:13 PM
Edit Legend Wording Paul Charts and Charting in Excel 1 October 30th 08 12:36 AM
Resizing trendline title in legend [email protected] Charts and Charting in Excel 2 May 18th 07 12:11 AM
How do I edit label when cursor is placed on trendline in excel? DaveOG Charts and Charting in Excel 1 October 23rd 06 10:48 PM
XY Scatter Legend when Edit Individual Markers John Charts and Charting in Excel 6 June 13th 05 03:06 PM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"