In Excel, how do I change the increments on the vertical axis?

Question

I have a line graph that reads numbers 0 , .5 , 1 , 1.5 , 2 , 2.5 and so on for unit numbers on the vertical axis. I would like to change the increments to whole numbers only so 0 , 1 , 2 , 3 , 4. I've been reading through all the help features but no luck.

Please help!

Thank you in advance.

Answer 1

Favourite answer

Go to your plot... double click on the Y scale, go to top option called Scale and change "major unit" to 1

Answer 2

I think right clicking on that axis will open up a menu to change the increments.

Answer 3

Have you tried Right-Click on the vertical axis itself, and exploring all of the properties tabs?

(Sorry I can't be more specific - I don't have Excel on this machine.)