Format axis on chart on dashboard
I have a stacked bar chart that is budget consumed/remaining. I do not want to show any decimal places on the x-axis labels. I have changed the number of decimals in the sheet from which I'm pulling the data, I've even made it No Currency but only the $ disappeared, not the .00s. How do I make those go away?
Thanks in advance.
Answers
-
Hi @cgoodenough
Is it possible that even one cell in that column that's being referenced in the Chart still has the decimal formatting applied? If there's one cell with 6.00 and another cell with 5, the Chart Widget will default to the decimals showing, so it will show both 6.00 and 5.00 in the labels.
Try highlighting the entire column and then adjusting the decimals in the toolbar menu to ensure all of the cells are formatting the same.
Then I would suggest (after saving), try logging out of Smartsheet and log in again to see if your Dashboard updated. It should update right away, but logging out/in again may help it recognize the change.
Cheers!
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives