Thread: LegendEntries
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default LegendEntries

Hi Bob,

In essence delete the legend and start again. I posted an example to
hide/unhide a series and its legend entry in this thread -

http://tinyurl.com/2ape9q

In passing, note with your 'LegendEntries(i).Delete', the only time you can
be sure the legendentries index correlates with the related series index is
just after creating a legend, when all keys exist, on a single axis chart,
and all series are the same chart-type.

Regards,
Peter T


"Bob Davison" wrote in message
...
Hello-

I have multiple series on a chart and only a few display at any time based
on a UserForm selection.

I wish to have a legend displayed at all times, showing only the
LegendEntries for the series that are currently visible. The
.Legend.LegendEntries(i).Delete method takes them off nicely. How do I

get
the specific series legend entries back into the legend when other series
are visible the chart? I can't seem to find the method.

Thanks,

Bob