Need help with the legend

[phillygirl777]

I have a chart that has 5 different categories of data (e.g., products). The chart is linked to a drop-down list that contains over 50 departments. Some of them have only 1 or 2 products, but the legend is still displayed for all 5. Is there a way to exclude the legend for the rows that have all zeros across the board? For instance, if the department has only Product 1 and Product 5, we do not get to see Products 2, 3, and 4 in the Legend box?

Thank you!

 

[Sajan]

Hello,
Can you check if the following article on non-contiguous ranges helps?

Cheers,
Sajan.

 

[phillygirl777]

It should help, thanks.