Pie Chart breaks when values are zero

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!