Ten Minute Guide to Excel 97

Changing the Start and Stop Values

You can change the start and stop value used on the value axis (the axis against which the values are plotted—typically, the y-axis), or you can change the interval between gridlines. You might need to do this, for example, to shorten the value axis in order to draw attention to the difference between two data series. Follow these steps:

1. Select Value Axis from the Chart Objects drop-down list on the Chart toolbar.

2. Click the Format Object button.

3. Click the Scale tab, and you'll see the options shown in Figure 24.1.

   Figure 24.1. Change the gridline values with the Scale tab.

4. Change the minimum or maximum values ...