Change Scale Of Value Axis. By changing your Y-Axis MinMax effectively zooming in you can clearly see in October your 2016 forecast might need a little adjusting. What I did till now is.
What I did till now is. To change the scale of the axis select one of the following options. In Excel 2013 you can change the scale of axis in a chart with following steps.
If you think the scale of axis is so large you can type a smaller unit whereas type a larger unit.
This means that scale may and probably will change when you zoompan the chart or toggle some series. Select the axis that we want to edit by left-clicking on the axis. Click Close to exit dialog. To change the range of a continuous axis the functions xlim and ylim can be used as follow.