Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Excel Screenshot

On the above Excel screenshot, how can I get the side numbers (y-axis) to only go up to one or two? So it does not show 0.2, 0.4 etc so it only says 0, 1, 2, 3 etc.



share|improve this question
up vote 2 down vote accepted

You need to go through the axis settings. There, you have to change a couple of things. My Excel is German, so you will have to guess the names of things.

  • Left-click the axis on the left side. It shows up selected with a box.
  • Right-click and select Format diagram (or similar).


  • In the window, stay in the top item of the list on the left (Axis options).

    Options window

  • On the right, the top four properties are what we want to change. They are all set to Auto by default. You can change them to reflect the look you want. I chose 0, 3 and 1 for the first three and left the fourth value on Auto since it doesn't seem to do anything.

    Change the first three values

The diagram now looks like this:

Altered diagram

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.