Possible to manipulate Legend?

  • Thread starter Thread starter SiriS
  • Start date Start date
S

SiriS

:rolleyes: Hi,
is it somehow possible to manipulate the legend of a chart?

I would like to only show the first, say, four series in the legend of
a chart even if there are, say, seven series available. Is this
possible?

Thank you,
Siri
 
Siri -

To remove unwanted legend entries:

1. Select the legend
2. Select the unwanted legend entry (the text label, not the marker)
3. Press Delete

To undo this, you need to delete and reinstate the entire legend.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Hi Jon,
Thanks! Had earlier tried to select and delete the marker which made
the whole series to disappear, had not noticed that the text label also
could be selected...

/Siri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I find the series associated with a given legend entry. 4
Excel 2007. Is it possible to format Legend Key? 3
Changing/Manipulating Legend range for a Pivot Chart in XL2010 vsXL2003 and below. 0
Legend changes after closing file 1
chart legend changing when I use Select data 1
Dynamic chart legends 1
Scatterplot chart legend 5
Ignore a Blank Data Series in the Legend 1

Back
Top