How to change the value axis scale in Microsoft® Excel
Follow the instructions to change the value axis scale in Microsoft Excel:
Activate the chart.
Select the on) value axis.
Select the ‘Format’ menu and select ‘Select Axis…’. (The ‘Format Axis’ dialog box appears.)
Click the ‘Scale’ tab.
Type the desired values in the appropriate boxes.
In the ‘Crosses At’ box, type the value where the category axis (or floor for a 3-D chart) should cross the value axis for all charts, except Radar.
The typed values will change the low (minimum) and high (maximum) values, or in-between intervals (major and minor units) on the axis. ‘Auto’ check boxes are cleared when custom values are typed. Select the ‘Auto’ check box in front of the desired option to restore its original default value.