You can manually set the y-axis range by using the Edit chart styles icon. The style panel includes the option to manually set the y-axis range. To set the y-axis range:
While viewing your answer as a chart, click Edit chart styles.
Under Y-Axis Range enter your preferred start and end values.
In this example, our original chart is showing sales values by department from 0 to over $10M. We can enter a y-axis range of
1000000to show only sales between $5M and $10M.
The chart will reorganize itself to reflect the new y-axis range.