Graph - Vertical Axis doesn't have the correct format

Gaurav Chauhan

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.

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.

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 .