# How to Add Two Data Labels in Excel Chart (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool for dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. With the help of Excel, we can represent our dataset in graphical forms. This helps us enrich the content of any presentation or report. Meanwhile, if we need to add two labels to a chart, we can do it in Excel. In this article, I will show how to add two data labels in Excel chart.

## Download Practice Workbook

Download this dataset and practice while going through this article.

## 4 Quick Steps to Add Two Data Labels in Excel Chart

This is the dataset that I am going to use in todayâ€™s article. We have some products along with their supply and demand in units. We will demonstrate the supply and demand in a chart.

### Step 1: Create a Chart to Represent Data

First of all, I am going to create a chart to represent my dataset. To do so,

• Select B4:D10. Then go to the Insert tab >> select the drop-down >> select any chart.

• Excel will create a chart.

### Step 2: Add 1st Data Label in Excel Chart

Now, I will add my 1st data label for supply units. To do so,

• Select any column representing the supply units. Then right-click your mouse and bring the menu. After that, select Add Data Labels.

Similar Readings

### Step 3: Apply 2nd Data Label in Excel Chart

In this section, I will show how to apply another data label to this chart. Letâ€™s express the demand units this time.

• Select any column representing demand units. Then right-click your mouse to bring the menu. After that, select Add Data Labels.

• Excel will add data labels for 2nd time.

### Step 4: Format Data Labels to Show Two Data Labels

Here, I will discuss a remarkable feature of Excel charts. You can easily show two parameters in the data label. For instance, you can show the number of units as well as categories in the data label.

To do so,

• Select the data labels. Then right-click your mouse to bring the menu.

• Format Data Labels side-bar will appear. You will see many options available there.

• Check Category Name. Your chart will look like this.

• Now you can see the category and value in data labels.

## Conclusion

In this article, I have explained how to add two data labels to in Excel chart. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.

## Related Articles

#### Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF