Microsoft Office Tutorials and References
In Depth Information
Working with Data Labels
Figure 7-33: Positioning data labels on series markers.
To make your markers large, right-click on any of the markers in your series and select
Format Data Series. This will activate the Format Data Series dialog box. Click on the Fill
& Line icon (the paint bucket) and choose Marker Maker Options. Adjust the Size ➜
property to make your markers as big as you need them to be.
To override a particular data label with other text, select the label and enter the new text. To select an
individual data label, click once to select all the data labels; then click the specific data label to select it.
To link a selected data label to a cell, follow these steps:
1. Click in the Formula bar.
2. Type an equal sign (=).
3. Click the cell that contains the text.
4. Press Enter.
After adding data labels, you’ll often find that the data labels aren’t positioned optimally. For
example, one or more of the labels may be obscured by another data point or a gridline. If you select
an individual label, you can drag the label to a better location.
Problems and limitations with data labels
As you work with data labels, you will probably discover that Excel’s Data Labels feature leaves a bit
to be desired. For example, it would be nice to be able to specify a range of text to be used for the
data labels. This would be particularly useful in scatter charts in which you want to identify each data
point with a particular text item. Figure 7-34 shows a scatter chart. If you would like to apply data
labels to identify the student for each data point, you’re out of luck.