Graph - Vertical Axis doesn't have the correct format

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

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    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

  • Gaurav Chauhan
    Gaurav Chauhan ✭✭✭✭✭✭

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!