Microsoft Office Tutorials and References
In Depth Information
Adding Data Labels
Adding Data Labels
Data labels show the numeric values (or other information) that are represented by each
bar or other shape on the chart. These labels are useful when the exact numbers are impor-
tant or where the chart is so small that it is not clear from the axes what the data points
To turn on data labels for the chart, do one of the following:
Click the Chart Elements icon to the right of the chart, and in the panel that
appears, mark the Data Labels check box. This method places plain black numeric
labels on each data point, with a transparent background on the data label box and
no border.
Data Callout. This method places white callout boxes for each data point, showing
both the numeric value and the category name.
If you want additional options besides those two data label types, follow these steps:
Click Chart Tools Design
Chart Layouts
Add Chart Element
Data Labels
1. Select the data series or data point you want to affect. To select a data series,
click one of the bars (or other shapes) in the desired data series. To select a single
data point, click again on the same bar (or shape).
In a multiseries chart, only one series’ data labels change at once when you make data label changes with the
Format Data Label task pane. Make the changes you want to make to the i rst series, and then select the next data
series in the chart (for example, the next color of bars on a column chart) and repeat the process.
2. Choose Chart Tools Design
Chart Layouts
Add Chart Element
More Data Label Options to open the Format Data Labels task pane.
Make sure the Label Options heading is selected, and make sure the Label Options
icon is selected. If needed, expand the Label Options controls under the icon, as
shown in Figure 12.21. The options available depend on whether it’s a 2-D or 3-D
chart and on what type of chart it is. Figure 12.21 shows the options for a 3-D col-
umn chart.
3. Mark or clear the check boxes for the types of label content under the Label
Contains heading. For example, you can show the series and/or category name, the
value, and the legend key (the colored square that represents the series name).
4. If you are working with a 2-D chart, choose a label position from the Label
Options controls in the task pane. A label can be on the center of the bar (or
other shape), inside it, or outside it. This option does not appear when you’re work-
ing with a 3-D chart.
Search JabSto ::

Custom Search