Possible to manipulate Legend?

[SiriS]

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

 

[Jon Peltier]

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/
_______

 

[SiriS]

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