118 Excel
categories with different symbols. For example we can divide the universi-
ties into two groups: one in which the percentage of freshmen who gradu-
ated in the upper quarter of their class is less than 80% and another group
consisting of schools in which 80% or more of freshmen graduated in the
upper quarter of their high school class.
To do this with Excel, you have to copy the values for these universities
into two separate columns and then recreate the scatter plot, plotting two data
series instead of one. That can be a time-consuming process. To save time, you
can use StatPlus to break the scatter plot into categories for you. You’ll try this
now, using the Top 25 Rate column to determine the category values (,80% or
.580%). First, you’ll make a copy of the scatter plot you created earlier.To copy the scatter plot:1 Right-click the Graduation Chart sheet tab and select Move or Copy
from the pop-up menu that appears. Excel opens the Move or Copy
dialog box.
2 Click the Create a copy checkbox and select Bubble Chart from the
list of chart sheets as shown in Figure 3-30.
Figure 3-30
Moving or
copying a
chart sheet3 Click the OK button.
Excel inserts a new chart sheet named Graduation Chart (2) directly
before the Bubble Chart chart sheet.
4 Click any one of the plot symbol labels to select them all and then
press the Delete key.