Data Analysis with Microsoft Excel: Updated for Office 2007

90 Excel

Once you’ve created the basic scatter plot, you can format its appearance

using the commands on the Chart Tools ribbon. Note that the Chart Tools

ribbon is a contextual ribbon and will appear within the Excel window

whenever a chart object is selected in the new workbook. Newly created

charts are selected by default.

EXCEL TIPS

When you insert a scatter plot using Excel, the column of data

values to the left will be used for the x values, the column on the

right will be used for the y values. If your columns are not laid

out this way, then do the following:

a. Generate the scatter plot with the two columns as they are

currently laid out.

b. Click the Select Data button from the Data group on the

Design tab of the Chart Tools ribbon to open the Select Data

Source dialog box.

•

Chart Tools ribbon appears when chart is selected

selected plot

Figure 3-7

Embedded

scatter plot