How Do I remove the zeros from my charts?

I am relatively new to charts and everything is a bit of trial and error, and googling. However one thing I haven't been able to do is to prevent zeros showing in my column charts.

I have tried using a table, using the error function to replace the zero with "", but they refuse to go away,

I'd like to remove the zeros showing in the four charts on the left.

Can anyone hlep me please? I have attached a copy of the spreadsheet.

In the attached I've formatted your data labels on the charts with a custom format #;;"".
This turns the zeros off.

Hope it helps.

BSB

Thanks very much.

I wasn't aware of the custom function. It works perfectly.

Happy to help And remember, it's only easy when you know how!

BSB