Format Data Labels all at once

[eoinymc]

Hi,

wondering if anyone can help me,

I have a chart which has a LOT of series...and I want to show the data labels of only the series, which aren't equal to zero.

So, basically, the way around this I have is to format the data labels to "#" (which sets zero to blank).

However, I can only seem to do this once data label series at a time.

Am I missing something? Is there a way to format all the data labels to the same number format?

Thanks,

E