112 Excel
As you did earlier in creating the scatter plot, you now have to format the
appearance of the chart to make it easier to interpret and understand. You’ll
move the chart to its own chart sheet, add titles, and change the axis scales.To format the bubble plot:1 With the chart still selected click the Move Chart button located in
the Location group of the Design tab under the Chart Tools ribbon.
2 Click the New Sheet option button in the Move Chart dialog box,
enter Bubble Chart in the New Sheet text box and then click the OK
button.
3 Click the chart title and change it from Graduated to Graduation
Rates for Different Top 25 Percent Rates.
4 Click the Legend button from the Labels group on the Layout tab
of the Chart Tools ribbon and then click None to remove the chart
legend.
5 Click the Axis Title button from the Labels group, click Primary
Horizontal Axis and then click Title Below Axis. Type Calcu-
lated SAT Values for the horizontal axis title. Set the font size to
14 points.
6 Click the Axis Title button again from the Labels group, click
Primary Vertical Axis, and then click Rotated Title. Type Graduation
Percentages for the vertical axis title. Set the font size to 16 points.
Now change the scale of the horizontal axis to go from 1000 to 1500
in intervals of 50 points.
7 Click the Axes button from the Axes group on the Layout tab of the
Chart Tools ribbon and then click More Primary Horizontal Axis
Options.
8 Within the Axis Options tab, set the Minimum fi xed value to 1000 ,
the Maximum fi xed value to 1500 , and the Major Unit value to 50.
Click the Close button.
Change the scale of the vertical axis to range from 50 to 100 in steps
of 5.
9 Click the Axes button and then click More Primary Vertical Axis
Options. Within the Axis Options tag of the Format Axis button set
the Minimum value to 50 , the Maximum value to 100 , and the Major
Unit value to 5. Click the Close button.