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.
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:
- 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.
- At this time, we will be able to see the data labels on the chart.
- 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.
- After that, type ‘=’ in the formula bar.
- After selecting the corresponding cell in a different column, click the Enter button.
- In turn, the formula bar will show the selected cell like the screenshot below.
- 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.
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:
- In the beginning, right-click on the data series of the chart.
- Next, select Add Data Labels and click Add Data Labels.
- Now, we can see in the screenshot below that all the data labels are added successfully to the chart.
- After that, right-click the data series and click Format Data Labels.
- 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.
- After choosing the desired column in the pop-up dialog, click on the OK.
- At this time, the text labels contain both the previous and changed data.
- 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.
- Ultimately, we can see the specified text labels added to the chart properly.
- 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.
- How to Add Text to End of Cell in Excel (6 Easy Methods)
- Combine Text and Formula in Excel (4 Simple Ways)
- How to Combine Text and Number in Excel (4 Suitable Ways)
- Add Text in Excel Spreadsheet (6 Easy Ways)
- How to Add a Word in All Rows in Excel (4 Smart Methods)
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.
- 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.
- 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.
- 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:
- In the beginning, go to the Insert tab and select Text Box from the Text section.
- Then, draw a text box beside a data point.
- 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.
- First, select the chart.
- Secondly, click on the ‘+’ sign.
- After that, the Chart Elements pane will pop up.
- Now, untick the Data Labels option.
- In the end, all the data levels are removed perfectly.
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.