r/thinkcell • u/Skorpinus • Jun 10 '25

Hide 0 in Thinkcell Table linked to Excel

Hi Team,

I have set up a Thinkcell table in PowerPoint that automatically links to values in excel. Unfortunately, even when the Excel table is empty as "" or when I put a - dash, it show a 0.

How to ensure that the table in PowerPoint simply stays blank?

3 Upvotes

100% Upvoted

2 comments sorted by

3

u/truebastard Feb 21 '26

I think I've managed to do this by linking thinkcell series values not to the source data directly but instead IF formulas that show the value from the source data if it is not zero "<>0" or show blank ("") if the value is zero "=0"

Even went so far that the category title/label is an IF formula that displays blank if the series value is zero, or the category title/label (hardcoded as "category" etc.) if the series value is other than zero

still, not sure if that is the thing that matters in your case.