Monday, October 14, 2013

How to Add Data Labels to an Excel Chart


1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to add data labels.
2. Select the chart you want to add the data labels to by clicking it. The chart will be surrounded by a light blur border indicating it is selected.
3. Choose the 'Layout' tab at the top of the Excel 2007 screen to display the options in the 'Layout' ribbon. Locate the 'Labels' group in the 'Layout' ribbon.
4. Click the 'Data Labels' button in the 'Labels' group of the 'Layout' ribbon to display a drop-down list of options.
5. Opt for 'Center' from the 'Data Labels' drop-down list to display the data labels centered on the data points of your chart. 'Inside End' will display the data labels inside the end of the data points while 'Inside Base' will display the data labels inside the base of the data points.
6. Watch as the data labels are added to the selected Excel chart in the position you have chosen.

Blogger news