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.

Please help!

Thank you in advance.

3 Answers

Relevance
  • Cletus
    Lv 5
    1 decade ago
    Favourite answer

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

  • Anonymous
    1 decade ago

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

  • Joe
    Lv 7
    1 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.)

Still have questions? Get answers by asking now.