Ability to Suppress Zeros in a Chart

Hello All,hoping this is a quick question, is a there a way to suppress zeros in a bar chart so they do not show and I do not have to manually delete each label. I am working with charts on a dashboard using dynamic data and trying to eliminate as many manual clicks as possible, sometimes with a large amount of data that requires many clicks to manually remove "0" values from a stacked bar chart.

Thanks for any input!

Sheryl

Format Data Labels > Edit Numberformatting, e.g. to "0;-0;"

THANK YOU! That was easy!

You're welcome, glad it worked

If that answers your Excel issue, it would be great if you could mark this thread solved (Select Thread Tools > Mark thread as Solved)

Cheers,
berlan