HI all

I want create a stack column chart but some legend is blank or zero. So how i can hide this legend which contains zero or blank cell without using pivot table. i have to create same chart for around 60 table, some table there is 6 legend and some 8 legend.. I read old post following is the link, my problem is same but i am using stack chart not pie chart

http://www.excelforum.com/excel-char...-or-blank.html