Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 3 Working with Charts 119

The plot labels disappear (you won’t be using them in the plot you’ll cre-

ate next). Now, break the points in the scatter plot into two categories on the

basis of the values in the Size column.

To break the scatter plot into categories:

1 Click Display series by category from the StatPlus menu located in

the Menu Commands group on the Add-Ins tab.

2 Click the Categories button.

3 Verify that the Use Range Names option button is selected, click

Top_25_Rate from the list of range names, and click OK.

4 Click the Bottom option button to display the categories’ legend at

the bottom of the scatter plot.

5 Click the OK button. Figure 3-31 displays the scatter plot broken

down by categories.

Figure 3-31
Breaking
the scatter
plot into
categories