Chapter 3 Working with Charts 1075 Click cell A1 to remove the highlighting.
Labeling Data Points
You can also use the StatPlus add-in to attach labels to all of the points in
the data series. These labels can be linked to text in the worksheet so that if
the text changes, the labels are automatically updated. Use StatPlus now to
add the university name to each point in the chart.To add labels to the chart:1 Return to the Graduation Chart chart sheet and then click outside of
the chart to deselect it.
2 Click a plot symbol from the chart again to reselect all of the plot
symbols.
3 Click Label series points from the StatPlus menu located in the
Menu Commands group on the Adds-Ins tab. Excel opens the Label
Point(s) dialog box.
Most StatPlus commands give you the choice of entering range
names or range references. Because range names have already been
created for this workbook, you can select the appropriate range
name from a list box. In this case, you’ll use the text entered into the
University column from the worksheet.
4 Click the Labels button to open the Input Options dialog box and then
click the Use Range Names option button, if necessary, to select it.
5 Scroll down the list box and click University and then click the OK
button.
6 Click the Link to label cells checkbox.Figure 3-21
Selecting
the data row
for a plot
point