How to Add Data Labels to a Chart in Excel 2007
9 of 12 in Series: The Essentials of Working with Charts in Excel 2007
You can add data labels to an Excel 2007 chart to help identify the values shown in each data point of the data series. Excel provides several options for the placement and formatting of data labels.
Use the following steps to add data labels to series in a chart:
Click anywhere on the chart that you want to modify.
A menu of data label placement options appears. Choose from the following:
None: The default choice; it means you don’t want to display data labels.
Center to position the data labels in the middle of each data point.
Inside End to position the data labels inside the end of each data point.
Inside Base to position the data labels inside the base of each data point.
Outside End to position the data labels outside the end of each data point.
Select where you want the data label to be placed.Data labels added to a chart with a placement of Outside End.
Click Data Labels→More Data Label Options on the Chart Tools Layout tab.
The Format Data Labels dialog box appears. You can use the options on the Label Options, Number, Fill, Border Color, Border Styles, Shadow, 3-D Format, and Alignment tabs to customize the appearance and position of the data labels.
If you don’t want the data label to be the series value, choose a different option from the Label Options area.
You can change the labels to show the Series Name or the Category Name.
Select Number in the left pane and then choose a number style for the data labels.
Customize any additional options and then click Close.
You can easily remove the data labels by clicking the Data Labels button in the Labels group of the Chart Tools Layout tab and then selecting None from the drop-down menu.