Graph - Vertical Axis doesn't have the correct format
![Gaurav Chauhan](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi Team, Can you please help find the Root cause. I have the below 2 graphs populated from the same base sheet wherein one of the graphs show the Vertical axis with $ values on scale and the other does not. Can you help why the difference.
Answers
-
Usually when I see this, it just means that there's one value snuck into your number set that isn't formatted to $. You could have 10k data points all formatted to $, but if one is just a regular decimal number it removes the formatting from the graph.
Double check your source, and hopefully you can find a number that just needs to be formatted properly.
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
@Jason Tarpinian , Thank you. it made me recheck the Report which populates the chart. Since the base sheet column field is all tied to $ unit, I created a filter on Report to only pull "that are numbers".. This then excluded 0 or blanks etc.
This solved the issue. Thanks .
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62K Get Help
- 347 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 131 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!