How to Add Text Labels in Excel Chart (4 Quick Methods)

We can add text labels to the data points in a chart to quickly identify a data series. By default, the worksheet’s values are connected to the data labels but in some cases, we might need to include text labels from a different column. In this article, we will see some quick methods with examples and explanations to add text labels in the Excel chart.


Download Practice Workbook

Download the practice workbook from here.


4 Quick Methods to Add Text Labels in Excel Chart

Here, I’ve used an Excel workbook with multiple worksheets. The worksheets contain the same dataset. The dataset contains two columns named X and Y. Here, X and Y denote the Names and Marks of some students successively. From the dataset, we have inserted a chart.

4 Quick Methods to Add Text Labels in Excel Chart


1. Insert Text Labels Manually in Excel Chart from Another Column

Suppose, we have a chart containing the data of X and Y columns. Now, we need to add the text labels from the Text Labels column by replacing the X column. This procedure will show how to manually add a text label from the cell of another column to an Excel chart. The steps are shown below:

Insert Text Labels Manually in Excel Chart from Another Column

Steps:

  • Firstly, we need to right-click on the data series.
  • Then, select Add Data Labels.
  • Now, two options will be visible. In this case, we’ve to select Add Data Labels.

Insert Text Labels Manually in Excel Chart from Another Column

  • At this time, we will be able to see the data labels on the chart.

Insert Text Labels Manually in Excel Chart from Another Column

  • Next, click on any specified data label which we need to replace. It should be noted that we can select any specific data label only after selecting all the data labels.

Insert Text Labels Manually in Excel Chart from Another Column

  • After that, type ‘=’ in the formula bar.
  • After selecting the corresponding cell in a different column, click the Enter button.

Insert Text Labels Manually in Excel Chart from Another Column

  • In turn, the formula bar will show the selected cell like the screenshot below.

Insert Text Labels Manually in Excel Chart from Another Column

  • Consequently, the data label will be changed to the desired text label.

  • Finally, we can change all the data labels to the corresponding text labels one by one by following this method.

  • Moreover, we can change the position of the text labels. For doing so, at first, we need to select the text labels.
  • Now, the Format Data Labels window will appear on the right side of the worksheet.
  • At this moment, go to the Label Options menu.
  • Here, we can see that the Label position is Right on the chart.

  • Now select Left.
  • In the end, we can see that the text labels are shifted to the left of the chart.

Read More: How to Add Text to Cell Without Deleting in Excel (8 Easy Methods)


2. Batch Add Text Labels From Another Column

In the previous method, we added the text labels one by one. This is a very time-consuming method. In this method, we will add all the text labels from a different column at the same time. The steps for doing so are given below:

Steps:

  • In the beginning, right-click on the data series of the chart.
  • Next, select Add Data Labels and click Add Data Labels.

Batch Add Text Labels From Another Column

  • Now, we can see in the screenshot below that all the data labels are added successfully to the chart.

Batch Add Text Labels From Another Column

  • After that, right-click the data series and click Format Data Labels.

Batch Add Text Labels From Another Column

  • Hence, a Format Data Labels pane will appear.
  • Now, go to Label Options.
  • And then, give a tick mark in the box beside the Value From Cells option.

Batch Add Text Labels From Another Column

  • After choosing the desired column in the pop-up dialog, click on the OK.

Batch Add Text Labels From Another Column

  • At this time, the text labels contain both the previous and changed data.

Batch Add Text Labels From Another Column

  • Now, we need to exclude the previously added data labels which were in the Y column.
  • To do this, uncheck the Y Value box in the Format Data Labels pane under the Label Options menu.

Batch Add Text Labels From Another Column

  • Ultimately, we can see the specified text labels added to the chart properly.

Batch Add Text Labels From Another Column

  • Now, suppose we want to change the font color of a text label named Mick Lam.

  • For this, first, select the specific text label.

  • Then, right-click on the text and select the Font Color option to choose the desired color.

  • Finally, we can see the changed font color in the chart.

Read More: How to Add Text to Cell Value in Excel (4 Easy Ways)


Similar Readings


3. Use Excel Ribbon to Get Text Labels in Excel Chart

Let’s assume, we need to add text labels in the chart shown below. For this, firstly we need to add data labels to the chart. Previously, we have done it by selecting and then right-clicking the data series. We can also do this by using Excel Ribbon.

Use Excel Ribbon to Get Text Labels in Excel Chart

Steps:

  • In the first place, select the chart.
  • After that, select Chart Design in the toolbar.
  • Now, go to the Chart Layouts option and click on the Add Chart Element option.

Use Excel Ribbon to Get Text Labels in Excel Chart

  • Next, click Data Labels.
  • In turn, some Data Label Options will pop up.
  • Assuming, we want to add data labels on the right side of the graph.
  • To do so, click on Right to the Data Label Options.

Use Excel Ribbon to Get Text Labels in Excel Chart

  • Lastly, the data labels are added successfully to the chart.

  • Furthermore, we can replace the data labels with a different column named Text Labels by following the first two methods.


4. Apply the ‘Brute Force’ Technique for Adding Text Labels

Brute-Forcing’ refers to taking on the appearance anyone desires, regardless of its normal settings. By following the Brute Force technique, we will add the text labels by using Text Box.

Suppose, we need to add text labels from the Name column to the following chart. We are going to insert them by the Brute Force method:

Apply the ‘Brute Force’ Technique for Adding Text Labels

Steps:

  • In the beginning, go to the Insert tab and select Text Box from the Text section.

Apply the ‘Brute Force’ Technique for Adding Text Labels

  • Then, draw a text box beside a data point.

Apply the ‘Brute Force’ Technique for Adding Text Labels

  • Now, type the text from the Name column.

  • Finally, we can add all the text labels by the same procedure.


How to Remove the Added Text Labels in Excel Chart

Let’s imagine that we need to remove the text labels from the following chart. By following the steps below, we can do this very easily.

How to Remove the Added Text Labels in Excel Chart

Steps:

  • First, select the chart.
  • Secondly, click on the ‘+’ sign.
  • After that, the Chart Elements pane will pop up.
  • Now, untick the Data Labels option.

How to Remove the Added Text Labels in Excel Chart

  • In the end, all the data levels are removed perfectly.


Conclusion

I hope the above methods will be helpful for you to add text labels in Excel charts. Download the practice workbook and give it a try. Let us know your feedback in the comment section. Follow our website ExcelDemy to get more articles like this.


Related Articles

Sagufta Tarannum

Sagufta Tarannum

Hi, I am Sagufta. I have completed graduation in Civil Engineering from BUET. I am from Bogura. Currently I am living in Mirpur. I am very interested about research and innovation in the field of Civil Engineering

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo