I am looking for a way to hide zeros on the data labels of my graphs

Hi all,

My situation is that some of my raw data contains zeros, and so when i graph this data some of the series on the graphs have "0" labels. I do not want to delete these zeros one by one, and there is also the fact that my raw data is constantly changing. I think what is needed is a custom number format on my raw data that hides zeros in some way. Note that my data is in percentage form, so the custom format would need to take that into account.

Also, would there be a way to hide series in my graph that have zeros completely, so that for example a bar on a bar graph with a zero value is hidden entirely from the graph.

Thank you in advance