ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I remove an item from my legend, but leave it on my graph? (https://www.excelbanter.com/charts-charting-excel/167584-how-do-i-remove-item-my-legend-but-leave-my-graph.html)

Jodi

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.

John Mansfield

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.


Jon Peltier

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.





All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com