Pie Chart breaks when values are zero

Gajapathi R M

In a dashboard, pie charts are breaks the reference and shows as Unable to display chart when reference values are changed to zero as these vales calculated via formula. Only Bar charts are showing as No data to display. My end goal is to show as No data to display when values are zero. Kindly help me out here.

Paul Newcome

So is it a sheet that has the calculations on it or a row report? If it is a sheet then you can add 0.00001 to all calculations and decrease the shown decimals. This will maintain some data greater than zero but only display zero.

Gajapathi R M

https://community.smartsheet.com/discussion/106206/pie-chart-breaks-when-values-are-zero

@Genevieve P. @Paul Newcome

Paul Newcome

Are you using a report or sheet to populate the chart?

Gajapathi R M

It is a sheet cell range, It is not possible to convert into sheet as lot of different calcs are associated with it. So referenced graph directly in the sheet.

Paul Newcome

So is it a sheet that has the calculations on it or a row report? If it is a sheet then you can add 0.00001 to all calculations and decrease the shown decimals. This will maintain some data greater than zero but only display zero.

Gajapathi R M

Worked well. Thanks lot.

Paul Newcome

Happy to help. 👍️