Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 22
Default How do I remove an item from my legend, but leave it on my graph?

I have two lines in a line graph that mean the same thing, so I only want it
to appear in my legend, but still want both lines in my graph. I can't seem
to delete it from the legend without deleting the series from my graph. The
best I've done so far is to put in a blank series name, but the symbol still
shows twice.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 235
Default How do I remove an item from my legend, but leave it on my graph?

You will need to click within the legend twice to delete a single entry.
First, click once on the legend and you'll see little black "handles" appear
around the entire border of the legend. When you see the handles around the
border, slowly click again over the legend entry that you want to delete.
You should then see the handles appear around the legend entry. Now you can
hit the delete key to delete the single legend entry.

--
John Mansfield
http://cellmatrix.net





"Jodi" wrote:

I have two lines in a line graph that mean the same thing, so I only want it
to appear in my legend, but still want both lines in my graph. I can't seem
to delete it from the legend without deleting the series from my graph. The
best I've done so far is to put in a blank series name, but the symbol still
shows twice.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default How do I remove an item from my legend, but leave it on my graph?

Make sure the second click selects the text, not the symbol. Deleting the
symbol deletes the series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John Mansfield" wrote in message
...
You will need to click within the legend twice to delete a single entry.
First, click once on the legend and you'll see little black "handles"
appear
around the entire border of the legend. When you see the handles around
the
border, slowly click again over the legend entry that you want to delete.
You should then see the handles appear around the legend entry. Now you
can
hit the delete key to delete the single legend entry.

--
John Mansfield
http://cellmatrix.net





"Jodi" wrote:

I have two lines in a line graph that mean the same thing, so I only want
it
to appear in my legend, but still want both lines in my graph. I can't
seem
to delete it from the legend without deleting the series from my graph.
The
best I've done so far is to put in a blank series name, but the symbol
still
shows twice.



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
Remove the Formula but leave the value alone? paic101 New Users to Excel 2 July 8th 07 05:42 PM
How do I leave out blank cells in a line graph? Kirsty W Charts and Charting in Excel 1 March 1st 07 10:54 AM
How do I change the order of item in a legend for a chart? Melissa Charts and Charting in Excel 1 October 13th 06 02:50 AM
Can I remove just one title within a graph legend and not hide th. KLF Charts and Charting in Excel 1 September 7th 05 03:30 PM
Remove Legend Series GregBausman Charts and Charting in Excel 1 March 1st 05 11:07 PM


All times are GMT +1. The time now is 10:35 AM.

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

About Us

"It's about Microsoft Excel"