Hi,

There is no easy way to do want you describe.

The legend entrys order does not always match the seriescollection
indexing. Within the legend the order is determined by a combination of
the series chart type, axis location and series order.

The help says that the indexing of the legend is purely sequential and
you can not use the name to reference an entry.

Cheers
Andy

Intuitive Analyst wrote:
I have some ("dynamic") charts in Excel 2007 where I'd only like to show
certain legend entries. Specifically I have 2n+k series but only want to
show legend entries for n+k of them. I understand how to use the Delete
method of the LegendEntry object but I don't know how to map the index number
of a given LegendEntry to a particular series. For example, suppose all the
LegendEntries I'd like to delete have the word "blah" in them (obviously it's
something else). How do I loop through the LegendEntries collection to
delete the correct LegendEntry objects? Thanks in advance!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info