Get FREE Advanced Excel Exercises with Solutions!

The most popular tool for navigating large datasets is Excel. Excel allows us to do countless tasks with numerous dimensions. Excel may be used to visualize our dataset in graphical representations. This enables us to enhance any presentation or reportâ€™s content. In the meanwhile, we can use Excel to add two labels to a chart. Iâ€™ll demonstrate how to add additional data labels to an Excel chart in this article.

## How to Add Additional Data Labels in Excel Chart: Step-by-Step Procedures

I will use the following dataset called the Supply vs Demand Chart of ABC Traders. The dataset has three columns, B, C, and D called Product, Supply(Unit), and Demand(Unit). The dataset ranges from B4 to D10 cells. I will use the following dataset to add additional data labels in excel chart with four easy steps.

### Step 1: Create a Chart

This is the first step of this article. I have a dataset already. Now, I am going to create a chart to represent my dataset.

• First, select the dataset from C4 to D10Â cells.

• Go to the Insert tab in your toolbar.
• Then, go to the Recommended Chart
• After that, select any chart type.

• As a result, you will get the chart just like the picture given below.

Read More: What Are Data Labels in Excel

### Step 2: Add First Data Label on Chart

This is the second step of this article. I made a chart in the previous step. Now, I am going to add a first data label on the chart. Follow the step-by-step procedure.

• Select any column representing supply units.

• As a result, you will get the first data label just like the picture below.

This is the third step. This is the step where I will add the additional data label on the chart. Follow the following steps.

• First, select any data label representing demand charts.

• After that, select add data labels.

• Hence, you will find the data labels just like the picture given below.

### Step 4: Format Data Labels

This is the last but not the least step to add additional data labels. I am going to format the data label here. Follow the following steps. You can also follow the images attached with every step.

• Select the data labelsÂ option.

• After that, click on the format data labels.
• Meanwhile, a sidebar will appear.

• Then, click on any of the checkboxes.
• As a consequence, you will find the following result.

Read More: How to Edit Data Labels in Excel

## How to Change Data Labels in Excel

Here, in this part of this article, I will show you how to change data labels in Excel. Here, I will use the former chart. Follow the step-by-step procedures to change data labels in Excel.

Steps:

• First, right-click on the data labels of the chart.
• Then select the Format data labelsÂ option.

• Consequently, a side menu will appear.
• You will find the Label Position option in the side menu.

• Then, select the label position Inside End.

• As a result, you will find the final outcome just like the picture below.

## How to Format All Data Labels at Once in Excel

Here, I will show the procedure to format all data labels at once in Excel. I will use the same chart in this portion of this article. Follow the following procedure.

Steps:

• First, right-click on any of the bars to open the menu.
• Then, select the format data labels option.

• You will find the following options in the side menu. Select any of the options to format all data labels.

• For example, select the legend key checkbox.

• Consequently, you will get the following result.

## Things to Remember

• You apply this procedure to any other chart type in excel.

## Conclusion

In this article, I have explained how to add additional data labels to an Excel chart. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. I hope you have enjoyed the whole tutorial. If you have any queries, feel free to ask me in the comment section. Donâ€™t forget to give us your feedback.

## Related Articles

<< Go Back To Data Labels in Excel |Â Excel Chart ElementsÂ |Â Excel ChartsÂ |Â Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF