How to change the y-axis label to integer without decimal in excel?

Question

I have a bar chart that shows the count values of three events occur, which means the value will always be an integer. I try to adjust the decimal places under format axis of the bar chart but it appeared something like this. May I know any way to solve this problem so that the label of y-axis can be 0,1,2,3,... instead of 0,1,1,2,2,3? By the way, this is a pivot chart. Thank you.

Answer 1

Under axis options, change major unit to 1:

Answer 2

you simply need to change the units of your axis:

• Left-click on axis: format axis
• Under Axis Options -> Units -> Major: Change from "0.5" to "1".

If that doesn't help, maybe you can share your .xls sheet ?