In the shape's shapesheet you can set the cell HideText to the formula:
=STRSAME(TheText,"0")
This sets the value true if the shape text is equal to "0".
Is there any options to display or hide zero value in shapes?
Naung Mon
1
Reputation point
Is there any options to display or hide zero value in shapes?
2 answers
Sort by: Most helpful
-
Paul Herber 111 Reputation points
2022-06-12T07:25:05.35+00:00 -
Kamala Morgan 0 Reputation points
2024-11-06T23:03:51.41+00:00 I had a "0" appear in my org charts as well. Either at the top of in a box overlapping, depending on the shape style chosen. I found this "0" lived in a text box on its own and did not know where it was pulling from. On the Org Chart ribbon tab, select the drop down arrow under "Shapes" and it opens an Options box with two tabs. Select the "Fields" tab and there is a Block 1 and Block 2. The "0" was appearing because of the block 2. If you select "None" and press Ok, then the "0" disappeared.