Apr 13 2021 08:32 PM
First picture shows when all values are 100, the bar for 2nd, 3rd and 4th in the bar chart become like a 0 at axis (the bar chart becomes abnormal).
Second picture shows when I change one of the value, it becomes a normal bar chart.
How do I fix this?
Apr 13 2021 09:05 PM
@jane100 Check the number you have for the $1 item. I suspect it is something like 100.001, but formatted to be displayed without decimals. Then, the horizontal axis is set to start at 100, with number formatting without decimals. This results in your first picture. In the second picture the lower bound for the horizontal axis is probably reset to automatic with the result you have shown.
Apr 13 2021 11:42 PM
@Riny_van_Eekelen thank you.