Data Analysis with Microsoft Excel: Updated for Office 2007

108 Excel

By linking to the label cells, you ensure that any changes you make

to text in the University column will be automatically refl ected in

the labels in the scatter plot.

7 Click the OK button.

8 Click outside the chart to deselect. Your chart should resemble the

one shown in Figure 3-22.

Figure 3-22
Identifying
plot points by
university

STATPLUS TIPS

If you want to use the same text font and format in the worksheet

and in the labels, click the Copy label cell format checkbox in

the Label Point(s) dialog box.

If you want to replace the plot symbols with labels, click the

Replace points with labels checkbox in the Label Point(s) dialog

box. Be aware, however, that once you do this, you cannot go

back to displaying the plot symbols.

To label a single point rather than all of the points in the data

series, select only a single plot symbol and then apply the Label

Point(s) command from the StatPlus menu.

•

•

•