How to Add Center Data Labels to a Chart in Excel

Placing labels in the middle of your bars or columns in an Excel chart is one of the fastest ways to make your data more readable. Instead of forcing viewers to jump back and forth between the visual and the axis, centering the value directly on the chart element provides instant context. This guide will walk you through exactly how to add and position data labels to the center in Excel, an essential skill for creating clear and effective reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Basics: Adding Data Labels to an Excel Chart

Before we dive into positioning, let's cover the fundamentals of adding data labels to any chart. If you're already familiar with this, feel free to skip to the next section. For this example, we’ll use a simple column chart showing quarterly sales.

Imagine you have data like this:

• Quarter 1: $15,000
• Quarter 2: $22,500
• Quarter 3: $18,000
• Quarter 4: $28,000

Here’s how to quickly add the default data labels:

1. Create your chart: Highlight your data, go to the Insert tab, and choose your preferred chart type from the Charts group. We’ll use a 2-D Clustered Column chart.
2. Select the chart: Click anywhere on your newly created chart to select it. You should see a green plus (+) icon appear in the top-right corner. This is the Chart Elements button.
3. Add Data Labels: Click the + icon to open the Chart Elements menu. Simply check the box next to Data Labels.

Excel will immediately add labels to your chart. By default, it usually places them at the "outside end" of the columns or bars, meaning the values will appear just above or to the right of each shape. While this works, centering them can create a cleaner, more integrated look.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Position Data Labels in the Center

Now for the main event. Shifting your data labels to the middle of your chart elements requires just one extra click. It's a small adjustment that makes a significant visual impact.

Follow these quick and easy steps:

1. Open the Data Labels Menu: Click on your chart to select it. Click the green + icon again. This time, instead of just checking the box, hover over Data Labels and click the small arrow that appears to the right.
2. Choose the "Center" Position: A new menu will pop up with positioning options. Click on Center. Excel will instantly move all the data labels to the middle of their respective bars or columns.

That's it! Your chart now displays the values directly inside each column, making it much easier to digest the information at a glance.

Customizing Your Centered Data Labels for Maximum Clarity

Adding centered labels is a great start, but true data visualization mastery comes from customization. The default labels might be hard to read if the color contrast is low (e.g., black text on a dark blue bar). Fortunately, Excel gives you full control over the appearance of your labels through the Format Data Labels pane.

To open this pane, simply right-click on any of the data labels in your chart and select Format Data Labels... from the dropdown menu. A sidebar will appear on the right side of your screen with a host of options.

1. Changing Font Color and Size

This is the most common and impactful customization. When you have dark bars or columns, changing the label text to white is essential for readability.

• With the Format Data Labels pane open, make sure your labels are selected.
• Go to the Home tab on the Ribbon.
• Use the standard font tools to change the text color, make it bold, or adjust the font size until it looks right. A bold, white font often works best against a colored column background.

2. Formatting the Numbers

Does your chart show sales data? It looks much more professional with a currency symbol. Or maybe you're dealing with percentages? You can control this formatting directly from the formatting pane.

• In the Format Data Labels pane, click on the icon that looks like a bar chart (Label Options).
• Expand the Number section at the bottom.
• From the Category dropdown, you can select Currency, Percentage, Accounting, Number, and more.
• You can also control the number of decimal places for a cleaner appearance. For large numbers, removing the decimals is almost always a good idea.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Including Other Information Like Category or Series Names

Sometimes, just displaying the value isn’t enough. You might want to include the name of the category or data series within the label itself. This is especially useful for pie or doughnut charts.

• In the Format Data Labels pane, look under the Label Contains section.
• You can check boxes to include the Category Name, Series Name, or both.
• You can also choose a Separator (like a new line or a comma) to control how the information is displayed. For instance, you could show "Q2, $22,500" all in one label.

4. Using "Value From Cells" for Truly Custom Labels

This is an incredible feature for when you need complete control. Let's say you want to create a label that says "Best Quarter: $28,000" instead of just "$28,000". The Value From Cells option lets you do this.

1. First, create your custom labels in a new column adjacent to your data in the worksheet.
2. Next, open the Format Data Labels pane for your chart.
3. Under Label Contains, check the box for Value From Cells.
4. A small window will prompt you to select the data label range. Select the cells containing your custom text and click OK.
5. Finally, uncheck the "Value" box so that only your custom labels are shown.

This method gives you limitless flexibility to display exactly what you want inside your chart shapes.

Working with Centered Labels on Different Chart Types

The "Center" position works beautifully for bar and column charts, but its behavior can vary across other chart types. Here’s what to expect and how to handle it.

Column and Bar Charts

This is the ideal use case. The label is placed squarely in the middle of each bar or column. When paired with stacked bar/column charts, in particular, the centered label neatly identifies the value of each colored segment within the stack.

Pie and Doughnut Charts

On a pie chart, selecting "Center" places the label in the middle of each slice. This can be very effective, especially when paired with a white, bold font. Sometimes, however, smaller slices don't have enough space. In those cases, the "Best Fit" option is often a smarter choice, as Excel will automatically try to place the label inside but move it outside if needed for readability.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Line Charts

The "Center" option on a line chart places the data label directly on top of the data point marker. This can sometimes obscure the line itself. More often than not, the Above or Below positioning choices work better for line charts, as they give the label breathing room while still clearly associating it with its corresponding point.

Troubleshooting Common Issues

Even with these tips, you might run into a few common hurdles. Here’s how to solve them.

• A label is unreadable because the bar is too short: If a bar is too small to comfortably fit the label inside, you have a few options. You can reduce the font size of the labels, or you can manually move just that one troublesome label. To do this, click on the data labels once to select them all, then click a second time on the single label you want to move. Once it's selected by itself, you can click and drag it to a better position (e.g., just outside the bar).
• Labels look cluttered or overlap: This often happens with charts that have many data points close together. The best fixes are to either reduce the font size, round your numbers to have fewer digits, or consider an alternative positioning like "Inside Base" or "Inside End" which might prevent overlap.
• My labels didn’t update when my data changed: Excel data labels created using the standard method should update automatically when you change the source data. However, if you used the "Value From Cells" method, make sure the cells containing your custom labels also update correctly. A formula-driven custom label can help automate this.

Final Thoughts

Mastering data label positioning is a small detail that elevates your Excel charts from simple visuals to compelling, easy-to-read reports. By learning how to center your labels and customize their appearance, you empower your audience to understand the story behind your data without any extra effort.

While perfecting charts in Excel is a valuable skill, the process of pulling data, creating visuals, and constantly updating reports can be time-consuming, especially when your data lives across different platforms. We built Graphed to remove that friction completely. Instead of clicking through formatting panes, you can simply ask for the chart you want in plain English, and our tool generates connected, real-time dashboards for you in seconds. It allows your entire team to explore data, get answers, and make decisions without ever needing to build a pivot table first.