Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Add Additional Data Labels to Excel Chart

anThe 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.


Download Practice Workbook

Please download the workbook to practice yourself.


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

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.

Add a chart to add additional datalabels to excel chart

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

Add a chart to add additional datalabels to excel chart

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

Add a chart to add additional datalabels to excel chart

Read More: What Are Data Labels in Excel (Uses & Modifications)


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.

Add first datalabel to add additional datalabels to excel chart

  • Then, right-click your mouse.

Add first datalabel to add additional datalabels to excel chart

  • After that, select the option Add Data Label.

Add first datalabel to add additional datalabels to excel chart

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

Add first datalabel to add additional datalabels to excel chart

Read More: How to Add Data Labels in Excel (2 Handy Ways)


Similar Readings


Step 3: Add Additional Data Label on Chart

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.

Add additional datalabel to add additional datalabels to excel chart

  • Then, right-click on your mouse to bring the menu forward.
  • After that, select add data labels.

Add additional datalabel to add additional datalabels to excel chart

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

Add additional datalabel to add additional datalabels to excel chart

Read More: Data Labels in Excel Pivot Chart (Detailed Analysis)


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.

Formatting datalabel to add additional datalabels to excel chart

  • Then, right-click on your mouse to bring up the menu.
  • 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.

Formatting datalabel to add additional datalabels to excel chart

Read More: How to Edit Data Labels in Excel (6 Easy Ways)


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.

Read More: How to Change Font Size of Data Labels in Excel


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.

Read More: [Fixed:] Excel Chart Is Not Showing All Data Labels (2 Solutions)


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. You will find such exciting blogs on our website Exceldemy.com. 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

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo