Data Analysis with Microsoft Excel: Updated for Office 2007

98 Excel

4 Click the Fixed option button for the Axis maximum and enter 1500

in the accompanying text box.

5 Click the Fixed option button for the Axis major unit and enter 50

in the accompanying text box. Figure 3-14 shows the completed

Format Axis dialog box.

axis scale goes

from 1000 to 1500

in steps of 50

Figure 3-14

Setting the

axis scale

6 Click the Close button. Figure 3-15 shows the appearance of the

chart with the revised scale for the x axis.