Option to remove zeros from Scatter Charts
breso
✭✭✭✭
When using a scatter chart any value of 0 is plotted on the axis. It would be great to have an option to toggle off displaying these values. It crowds the scatter plot with junk information. Here is a before and after example where I use a formula on the metrics sheet to change any zero values to null values.
With 0 Values Plotted:
Without 0 Values Plotted:
Tags:
Comments
-
Can I ask what the formula was that you used?
-
It would be great to see the formula you used. I also was able to get my cell values to be Null but it still charted as zero on the scatter graph. We really need the ability to eliminate this useless data.
- Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our prod…
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Ideas
- With around 80 automations on some of our sheets, it would be great to have just a really simple folder view of automations. At the moment having to scroll endlessly (even though they are organised as…
- There should be a way to restrict dropdown options on forms that are external facing that also have internal uses without setting up additional reference or separate internal/external columns. Use cas…
- Is there or could there be a dark mode? My eyes are killing me with the super bright white screen.