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

How to Move Data Labels In Excel Chart (2 Easy Methods)

Excel is often used to make charts and graphs that show how data looks. We often put labels on charts to help us understand them better. Also we try to put the labels in different places depending on what we need. In this article, we’ll show you how simple it is to Move Data Labels in Excel Chart.


Download Practice Workbook

You can download the practice workbook from here.


2 Easy Methods to Move Data Labels In Excel Chart

We can move data labels in an excel chart using 2 different methods. To describe these methods and their steps properly, we can consider this table in the example below. It shows the monthly budget of a student to buy different study items.

And based on the table, we have a column chart like the image below.

2 Easy Methods to Move Data Labels In Excel Chart

The two different methods and their steps are given below.


1. Move Data Labels in Excel Chart by Drag & Drop Option

Drag and drop is the easiest method to move data labels in an Excel chart. To do so, we will follow these steps.

Steps:

  • To begin with, select the label we want to move. In our case, we want to move Pencil’s data label to a higher position.

Move Data Labels in Excel Chart by Drag & Drop Option

  • In addition, drag the label to any expected place. In our case, we will drag it higher.

Move Data Labels in Excel Chart by Drag & Drop Option

  • Finally, drop the data to the expected position and we will have our results.

Read More: How to Change Data Labels in Excel (with Easy Steps)


2. Use Format Data Labels Task Pane to Move Data Labels in Excel Chart

Using the Drag and Drop option, we can move only one data label to a certain place in the excel chart. But if we want to move all the data labels together to excel defined positions, we can use the Format Data Labels task pane right side of the screen. The steps are given below.

Steps:

  • Firstly double click on any of the data labels. This will open the Format Data Labels task pane.

Use Format Data Labels Tab to Move Data Labels in Excel Chart

  • Secondly, in the Format Data Labels task pane, select Label Options.
  • Thirdly, in Label Options, find Label Position and select the position where we want to move the labels.

Use Format Data Labels Tab to Move Data Labels in Excel Chart

  • Lastly, selecting any of the positions will reposition our data labels. For example, we want to show our data labels in the middle. So we will select Center. After selecting Center, the end result will look like the image below.

That’s how we move data labels in Excel very easily.

Read More: How to Format Data Labels in Excel (with Easy Steps)


Things to Remember

  • The Drag and Drop system moves only one label. To move all the labels, we will need to manually drag and drop labels. If there are a lot of labels, this method is lengthy.
  • Format Data Labels option is suitable if we need to move all the labels at once.

Conclusion

Showing Data Labels and modifying them is a very useful feature in Excel that is used very often. In this article, we saw how to modify the position of data labels in an excel chart very easily. If you’re still having trouble with any of these steps, let us know in the comments. Our team is ready to answer all of your questions. For any excel related problems, you can visit our website Exceldemy for all types of excel related problem solutions.


Related Articles

Nasir Muhammad Munim

Nasir Muhammad Munim

I am Nasir Muhammad Munim from Dhaka, Bangladesh. I work as an Excel and VBA Content Developer for Exceldemy right now. Electrical and electronic engineering was my major at Islamic University of Technology, where I got my degree. I love creative works and learning new things. And I'm really into online games, especially first-person shooter games.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo