Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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.

Thanks,

Jack

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).

    Context-menu

  • 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .