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


--
SiriS
------------------------------------------------------------------------
SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995
View this thread: http://www.excelforum.com/showthread...hreadid=522150

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" wrote in
message ...

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


--
SiriS
------------------------------------------------------------------------
SiriS's Profile:
http://www.excelforum.com/member.php...fo&userid=7995
View this thread: http://www.excelforum.com/showthread...hreadid=522150

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


--
SiriS
------------------------------------------------------------------------
SiriS's Profile: http://www.excelforum.com/member.php...fo&userid=7995
View this thread: http://www.excelforum.com/showthread...hreadid=522150