Excel bar chart becomes 0 axis when value 100, but becomes normal when one of the value not 100

%3CLINGO-SUB%20id%3D%22lingo-sub-2271512%22%20slang%3D%22en-US%22%3EExcel%20bar%20chart%20becomes%200%20axis%20when%20value%20100%2C%20but%20becomes%20normal%20when%20one%20of%20the%20value%20not%20100%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2271512%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20picture%20shows%20when%20all%20values%20are%20100%2C%20the%20bar%20for%202nd%2C%203rd%20and%204th%20in%20the%20bar%20chart%20become%20like%20a%200%20at%20axis%20(the%20bar%20chart%20becomes%20abnormal).%3C%2FP%3E%3CP%3ESecond%20picture%20shows%20when%20I%20change%20one%20of%20the%20value%2C%20it%20becomes%20a%20normal%20bar%20chart.%3C%2FP%3E%3CP%3EHow%20do%20I%20fix%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20658px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272684i17EE2E3F48635D15%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20657px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272685i2A576F33535118A6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2271512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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?

image.png

 

 

image.png

2 Replies

@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.