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.4 etc so it only says
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.
The diagram now looks like this: