0s on my charts

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

0s on my charts

cpezzcpezz
edited 12/09/19 in Using Smartsheet

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

  • 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

  • Thanks!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    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.

Sign In or Register to comment.