Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 3 Working with Charts 89

To insert a chart:

1 Select the cell range D1:E12.

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

and then click the Scatter with only markers option as shown in

Figure 3-6.

Insert tab

Figure 3-6
Inserting a
scatter plot

Excel inserts an embedded chart object containing the scatter

plot of the Graduated values versus the SAT calculated values

(see Figure 3-7).