Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 3 Working with Charts 121

these results needs to have several data series. You can create such a scatter

plot by simply selecting additional columns of data to be plotted on the

y axis of the chart. In this example you’ll plot the graduation rates for white

male and female athletes.

To create the scatter plot:

1 Return to the Grad Percents worksheet and select the nonadjacent

cell range D1:D12;F1:F12;H1:H12.

2 Click the Scatter button from the Charts group on the Insert tab and

then click the fi rst Scatter subtype, displaying a scatter plot with

only markers. Excel inserts an embedded scatter plot as shown in

Figure 3-32.

Figure 3-32
Plotting
the white
male and
female
graduation
rates

3 Move the scatter plot to its own chart sheet named Graduation Chart

by Gender.

4 Excel does not automatically add a chart title when there is more

than one data series being plotted. To insert a title, click the Chart

Title button located in the Labels group of the Layout tab on the

Chart Tools ribbon and then click Above Chart. Enter Graduation

Percentage by Gender for the title.