Add data labels to a chart in Excel – How to

Add data labels to a chart in Excel – How to

Add data labels to a chart in Excel - How to

The following lesson shows you how to add data labels to a chart in Excel.

Since we use Excel on a Windows PC to complete this task, we suggest you do the same. However, you can still follow along on any operating system that has Excel.

Introduction

Data labels shows the value of a particular item on a chart. Essentially, it adds value to a chart, and helps you compare data easier. Instead of just viewing a chart without labels, you get an exact value that you can report. And, that is what we plan to do.

If you do not have a chart to work with, then feel free to create the same chart we use here.

Steps to add data labels to a chart

Follow the steps below to add labels to a chart in Excel.

Step 1: Format the data series

Instead of using the menu method, we will use a slightly quicker way.

  1. Right-click on a data series. This shows you a shortcut menu.
  2. From the shortcut menu, select Add Data Labels.

There you go! Your chart now has labels. But, wait a minute. Sense our chart talks about revenue, let’s change the number format of the labels to reflect that point.

Step 2: Format the labels
Format data labels.
  1. Right-click on the labels. A shortcut menu appears.
  2. Select Format Data Labels from the shortcut menu. A dialog box opens to help you format the labels.
Add data labels to a chart - Format data labels.
  1. If you are not in the Labels Options area, then click Label options. It is the last option at the top of the box.
  2. Scroll down to the Number group. And, under Category select a number format. Since we are dealing with money, we chose Currency as our number format.

Success!

Add data labels to a chart - Show labels on the chart.

So, you now have labels on your chart. Congratulations!


Related


Excel lessons  Education home  Techronology home