3

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. 

Comments

SEAN WILLIAMS

You could change the formula in the sheet to insert NULL in place of a 0. This will remove the item from the chart. 

Sean

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.