Dashboard Chart Widget Vertical Axis Numbering
So, I have added a few new charts to an old dashboard, and for some reason the new charts are adding a decimal and two zeros to my vertical axis numbers. It isn't the end of the world if the numbers look like this: 5.00, 10.00, etc. But, I would prefer that they simply be whole numbers. In previous charts I have created they show as whole numbers no decimals. I am sure it is something simple, but I have been looking for an answer and can't seem to find it. Does anyone know offhand how to correct this? I have attached an image the top chart is one of the new ones with the undesired decimals, and the bottom is an older chart with the more concise whole numbers. All of the data sets are whole numbers in case that is thought to be an issue. I appreciate your help with this!
Comments
-
Check the number formatting on the source sheet. That's the only way I was bale to replicate it was by adding decimals there.
-
I am having the same issue. I have two bar chart widgets that come from the same column, different rows. One chart has decimals, the other has whole numbers?
-
@Ellen Rinker It looks like it may have to do with the size of the widget in relation to the values of the actual data. Try adjusting the size of the widget and see if that helps. If it does not... How are you populating the data for the widgets?
-
It is indeed due to the size of the widget in relation to the values of the actual data. I adjusted the size (i.e. made the chart wider) and the diagonal Horizontal Values straightened out completely. Thank you very much, Paul!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives