My chart has about a dozen data series in it, with a legend created for each.
A couple of the data series currently are zero amounts, and my boss prefers
not to show the legends for the zero amount data series in the chart legend.

I understand how to delete the legend name from the chart legend and leave
the data series as part of the chart. Is there some way to check each data
series when the chart (or worksheet) is activated, see if the amount is no
longer zero, and if so, reinsert the legend information for that data series
in the chart legend?

--
Bill @ UAMS