Hi,

I’m trying to create a graph with labels that will appear only when there are non-zero values in the cells. When I tick label contains Value and I add in the cusotm number format #”” the label dissappears when the cell value is zero. If I tick Label contains “Series Name” then the label always appears. Is there a way, custom format etc. to have the same behavious as when I’m using the cell value in the label?

Thank you all,

Tassos.

PS: O365 on Win 11 Pro 

​Hi,I’m trying to create a graph with labels that will appear only when there are non-zero values in the cells. When I tick label contains Value and I add in the cusotm number format #”” the label dissappears when the cell value is zero. If I tick Label contains “Series Name” then the label always appears. Is there a way, custom format etc. to have the same behavious as when I’m using the cell value in the label? Thank you all,Tassos. PS: O365 on Win 11 Pro   Read More

​