remove zero values from chart

Judith Zannoni

Hello,

How can I remove the zero values from my chart ? Actually, chart is huge, just because the horizontal information have not yet started.

Thanks !

Judith

Jennifer Lenander

This isn't perfect, but you could filter on zero values and CTRL+SHIFT+down and then delete.

Judith Zannoni

Thanks for your comments ! Maybe my question was not clear enough but the chart I use on my dashboard shows all vertically/horizontally axis, even if there if no information yet to show. So my chart is bigger which plenty blank information. . I was wondering if there is a way to only show axis that include datas ?

Ken Hallaran

If you are charting cells with formulas you can update your formulas to IF formulas so that they display blanks if your formula = 0. Example: my formula in cells I am charting is =SUM(X:Y). Instead of using that formula, change it to =IF(SUM(X:Y)=0,"",SUM(X:Y)). Charts wont display blank cells.

If you are charting cells with just numbers in them, I am not sure how to do it.

Rob Hamill

This was the answer I came for :)

https://community.smartsheet.com/discussion/comment/293737#Comment_293737