how to add data labels in excel

Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Adding Data Labels to Your Chart.

Adding Data Labels to Your Chart

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 in Excel 2007 or Excel 2010, 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.

To add data labels in Excel 2013 or Excel 2016, follow these steps:

Activate the chart by clicking on it, if necessary.
Make sure the Design tab of the ribbon is displayed. (This will appear when the chart is selected.)
Click the Add Chart Element drop-down list.
Select 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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6788) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Adding Data Labels to Your Chart.

Author Bio

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen...

MORE FROM ALLEN

Maintaining Proper Hyperlinks in Word 2000 and Later

Keeping hyperlinks properly working in a group of documents can be a challenge. Here's a way that you can make sure that ...

Discover More

Automatically Advancing by a Month

Excel allows you to perform quite a few operations using dates in your worksheet. Sometimes, however, the answer may not ...

Discover More

Getting Pictures Out of Word

If you receive a Word document from someone, you may want to get any graphics it contains into their own files. You can ...

Discover More

More ExcelTips (ribbon)

Controlling Chart Gridlines

Gridlines are often added to charts to help improve the readability of the chart itself. Here's how you can control ...

Discover More

Creating a Year-to-Date Comparison Chart

Excel is an excellent tool for keeping track of data over time. If you have information you are keeping by year, you may ...

Discover More

Exploded Pie Chart Sections

Want to change the groupings used by Excel when it creates pie charts? Your options are limited, as you learn in this tip.

Discover More