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

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

-JC


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=390746