Chart Legend Entries

[Guest]

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?

 

[carlyman]

The only "automatic" way I have found around this problem is to us
Pivot Charts. If there is no data for a series, it will not be show
on the legend.

And if for some reason it is on the legend, you un-select it from th
legend drop-down menu.

-J