Add Data Labels to a Chart

Summary: Adding labels to a chart can make the information presented in the chart more understandable. Excel allows you to add different types of data labels to your charts, as discussed in this tip.

Data labels are used to indicate what the main part of the chart represents. Depending on the type of chart you are creating, data labels can mean quite a bit. For instance, if you are formatting a pie chart, the data can be more difficult to understand if you don't include data labels.

To add data labels, follow these steps:

Activate the chart by clicking on it, if necessary.
Make sure the Layout tab of the ribbon is displayed.
Click the Data Labels tool. Excel displays a number of options that control where your data labels are positioned.
Select the position that best fits where you want your labels to appear.

Related Tips:

Great Idea! Word is a tool to get what you really want—printed output. This means you need to make sure that Word works as well as possible with your printer, whether it is sitting on your desk or in a room down the hall. Check out WordTips: Printing and Printers today!

Helpful Links

Newest Tips

Subscribe

Add Data Labels to a Chart