Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 3 Working with Charts 99

Now the data points are only compressed near the top of the chart. You

can change this by setting the scale of the graduation percentages on the

y axis to go from 50 to 100% in steps of 5%.

To change the scale of the y axis:

1 Click the Axes button from the Axes group on the Layout tab of the

Chart Tools ribbon, click Primary Vertical Axis and then click More

Primary Vertical Axis Options. Excel opens the Format Axis dialog

box for the vertical axis.

2 Click the Fixed option buttons for the Axis minimum, maximum,

and major units and change the minimum value to 50 , the maximum

value to 100 , and the major unit to 5.

3 Click the Close button. Figure 3-16 shows the revised scale for the

vertical axis on the chart.

axis scale goes from 1000 to 1500 in steps of 50

Figure 3-15
Revised scale
for the x axis