Hello - I'm creating basic bar charts and right now they look cluttered. How do I show the data values EXCEPT when that value is zero? I tried using the 0 formula on the source sheet, but it still showed up on the chart.
You could change the formula in the sheet to insert NULL in place of a 0. This will remove the item from the chart.
I generally use something along the lines of
=IF([Number Generating Formula] > 0, [Number Generating Formula])
This will leave the cell blank until the number is greater than zero.
You could even change the > to <> to get it to show negative numbers, but leave blank if zero.