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!