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.