CODEWITHSUNDEEP
excelformatpivot-chart
Elvis
Elvis

Reputation: 425

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

enter image description here

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.

Upvotes: 0

Views: 5457

Answers (2)

eirikdaude
eirikdaude

Reputation: 3255

Under axis options, change major unit to 1:

enter image description here

Upvotes: 1

Lena
Lena

Reputation: 321

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 ?

Upvotes: 0

Related Questions