hide 0 values in excel chart

[lyntan]

hello. i need help on hiding the 0 values in excel chart.

ive found things like "#" in format code but it rounded up my figures.

i have data like 1.7 or 6.5 and it rounded up.
is there a way to hide 0s in the series without changing the other figures in the series?

 

[jmacleary]

You could use conditional formatting to change the text colour of the cell to white when it has a zero value.