In Excel, how do I change the increments on the vertical axis?
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.
Thank you in advance.
- CletusLv 51 decade agoFavourite answer
Go to your plot... double click on the Y scale, go to top option called Scale and change "major unit" to 1
- Anonymous1 decade ago
I think right clicking on that axis will open up a menu to change the increments.
- JoeLv 71 decade ago
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.)