Hide data equal to 0 in charts

Corentin Dal Farra

Hello everyone,

Does someone know if there is a dynamic way in Smartsheet to hide all the values of a graphic that are equal to 0 ?

Here is my example, I have only data for 3 months, so I would like my chart only display the months in which I have data.

I tried to put NULL instead of 0, but it only hide the value on the curve so the month is still here in the chart.

Thank you for your help,

Corentin

Andrée Starå

Hi @Corentin Dal Farra

I'd recommend creating a report instead, and then you can configure it to not show the rows with 0.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Corentin Dal Farra

I'd recommend creating a report instead, and then you can configure it to not show the rows with 0.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Corentin Dal Farra

Hello Andrée,

Very interesting solution, thank you !

I have a question about report, if for example I have new values that comes up on new months, the chart will automatically takes all the month within the report or I have to adujst the data window each time I want to update my diagram ?

Thank you for your help, have a nice day !

Corentin

Andrée Starå

@Corentin Dal Farra

Thanks!

You're more than welcome!

Yes, as long as the report builder is configured, so it's included, it will update automatically.