How to Change Interval of Value Axis in an Excel Chart

1. Start Microsoft Excel 2007 and open a spreadsheet that contains a chart to which you would like to change the interval of the value axis.
2. Select the entire chart by clicking in the white area of the chart. You will then see a light blue outline around the chart indicating you have selected the entire chart.
3. Choose the 'Format' tab at the top of the Excel screen and location the 'Current Selection' group. The 'Current Selection' group is the first group that appears on the 'Format' ribbon.
4. Click the 'Chart Elements' drop-down list and select '(Value) Axis' from the list. The 'Chart Elements' list is the top item in the 'Current Selection' group.
5. Click the 'Format Selection' button to open the 'Format Axis' dialog box. Click the 'Axis Options' option on the left side of the 'Format Axis' dialog box if necessary.
6. Change the minimum value, maximum value, major units and minor units by clicking the 'Fixed' radio buttons beside the options. This allows you to be able to type in the intervals you want to see in the text boxes to the right of the options.
7. Click the 'Close' button to close the 'Format Axis' dialog box and return to your Excel chart. You will notice that the interval of the value axis has changed.