How to get rid of zeroes on a chart

[agd50]

How to make it so it won't show a bar if it's value is zero?

Regards,
Andrew

[PhilipTreacy · Accepted solution]

Hi @agd50 

Do you mean don't show a data label?  The image you provided isn't showing a column for the 0 values.

To hide the 0's, apply a custom format string 0;0;; to the values column

Regards

Phil