Microsoft Office Tutorials and References
In Depth Information
Working with Data Labels
It is not possible to apply different formatting to individual gridlines within
a set of gridlines. All gridlines in a set are always formatted identically.
Working with Data Labels
For some charts, you may wish to identify the individual data points in a series.
Excel’s data label feature provides you with several options. The types of
information that can be displayed in data labels are as follows:
The series name
The category name
The numeric value
The value as a percentage of the sum of the values in the series
The bubble size (for bubble charts only)
Not all these options are available for all chart types, and earlier versions of
Excel do not offer the category name option. If you select the check box labeled
Show Legend Key Next to Label, each label displays its legend key next to it.
For versions prior to Excel 2002, a data label can consist of only one of the
items in the preceding list. Excel 2002 enables you to display multiple items,
separated by a user-defined separator. If you use Excel 2002, be aware that
there are some known compatibility problems with data labels. If you plan
to share your workbook with users of earlier versions of Excel, limit the data
labels to display values only.
Adding or removing data labels
When you create a chart using the Chart Wizard, you can specify data labels in Step 3
(using the Data Labels tab). To add data labels to an existing chart, use the Data Labels
tab of the Chart Options dialog box (see Figure 4-32). In both cases, data labels are
added to all the series in the chart.
To add data labels to a specific series in the chart, select the series and access the
Format Data Series dialog box. Select the Data Labels tab and specify the type of
labels.
Search JabSto ::




Custom Search