How to change y axis values in excel?

It is quite straightforward. First, right-click on the vertical (Y) axis of your chart. Select 'Format Axis' from the context menu. A new pane will open on the right. Under 'Axis Options', which has a small bar chart icon, you will find what you need. You can manually set the 'Bounds' to define your minimum and maximum values. You can also change the 'Units' to control the spacing, or the interval, between your axis labels. Voilà, you have complete control over how your data is displayed. It gives your chart a much more professional look.