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
-
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.
Answers
-
Are you using a report or sheet to populate the chart?
-
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.
-
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.
-
Worked well. Thanks lot.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!