Excel: Chart: only show legend elements with values

Hi guys I have 10 graphs with more than 20 legend entries. However, each graph only needs 3-4 elements out of the 20 legend entries in the graph. Is there any way to force Excel to only show those legend entries that have a value? (without deleting them manually) Thanks in advance!

This question generated 48 answers. To proceed to the answers, click here.

This thread is current as of November 22, 2013.

For more resources for Microsoft Excel