How to Format Data Labels in Excel

A well-made chart can tell a story, but raw numbers on a graph don't always speak for themselves. This is where data labels come in, transforming a generic chart into a clear, compelling visual narrative. This guide will walk you through exactly how to add, customize, and format data labels in Excel, moving from the basics to advanced tricks that will make your data dashboards look truly professional.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First Things First: Adding Basic Data Labels to Your Chart

Before you can format labels, you need to add them. The process is straightforward and only takes a couple of clicks.

1. Create Your Chart: Highlight your data and go to the Insert tab. Choose your preferred chart type (e.g., Column, Bar, Pie, Line).
2. Add Data Labels: Click on your new chart to select it. You will see three small buttons appear on the right side. Click the plus sign (+) , which stands for Chart Elements.
3. Check the Box: In the menu that appears, simply check the box next to Data Labels. Labels showing the value of each data point will instantly appear on your chart.

That’s the basic starting point. Now, let’s get into the details that will make your charts stand out.

Accessing the "Format Data Labels" Pane

To access the full suite of formatting options, you need to open the "Format Data Labels" pane. Most of our customization will happen here.

Here’s how to open it:

1. With your chart selected, right-click on any data label. Make sure you click a label, not the chart area or a data series.
2. From the context menu, select Format Data Labels…

A pane will appear on the right side of your screen with several icons at the top: Label Options, Fill & Line, Effects, and Size & Properties. Let’s break down what you can do in each section.

Mastering Label Options

This first section (represented by a bar chart icon) controls what information your labels display and where they are positioned.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

What Your Labels Contain

Under the "Label Contains" heading, you'll see a series of checkboxes. This is where you can fundamentally change the information displayed on your chart.

• Series Name: Displays the name of the data series. This is most useful for charts with multiple series, like a stacked column chart showing sales from different regions.
• Category Name: Shows the name of the category for each data point (e.g., 'January', 'Q1', 'North Region'). This is helpful for pie charts or any chart where the x-axis labels might be hard to read.
• Value: This is the default setting, showing the numerical value of the data point.
• Percentage: In pie and donut charts, this calculates and displays the percentage contribution of each slice. For other chart types, if you check both Value and Percentage, Excel will display stacked values.
• Value From Cells: This is a powerful, advanced option. It allows you to select a range of cells in your worksheet to use as custom data labels. We’ll show a practical example of this later.
• Show Leader Lines: A must-have for cluttered charts. When you manually move a data label far from its data point, checking this box will automatically draw a line connecting the label to its corresponding point on the chart.

You can also choose a Separator (like a comma, a new line, or a space) to organize the information when you select multiple checkboxes, such as displaying the Category Name and Value together.

Choosing the Perfect Label Position

Below the content options, you'll find "Label Position." The available options change based on your chart type, but here are the most common ones:

• Center: Places the label smack dab in the middle of a bar or column.
• Inside End: Positions the label at the top inside edge of a column or the right inside edge of a bar.
• Inside Base: Puts the label at the bottom inside edge of a column or the left inside edge of a bar.
• Outside End: Sits the label just outside the top of a column or to the right of a bar. This is often the cleanest and most readable option.
• Best Fit: Excel automatically tries to determine the best place for the label based on the chart's spacing.

Customizing Number Formats

Does your data represent currency? Or maybe it's a date or a large number that needs a thousands separator. Instead of formatting your original source data, you can format the labels directly.

Scroll down to the Number section within the "Label Options" tab. Here, you'll have access to all of Excel’s standard number formatting settings. You can select a category like 'Currency', 'Percentage', or 'Date' and specify options like decimal places and currency symbols.

Enhancing Readability with Fill & Line and Effects

Sometimes, labels can get lost against a busy chart background. The next two sections in the formatting pane help you make your labels pop.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Fill & Line

Click on the paint bucket icon (Fill & Line). Under the Fill dropdown, you can add a colored background to your data labels. A subtle, semi-transparent solid fill can be a great way to separate a label from a similarly colored chart element. You can also add a border around each label under the Border dropdown, helping to neatly box them in.

Effects

Click the pentagon icon (Effects). Here you can add subtle visual flair like Shadow, Glow, or Soft Edges to your data label boxes. A little shadow can often make labels appear as if they're floating slightly above the chart, which can massively improve readability.

Adjusting Size & Properties

The last tab (a box with arrows) handles alignment and text orientation.

Under Alignment, you can control vertical alignment and text direction. For instance, rotating your labels 90 degrees can help them fit better on a chart with very narrow columns.

Practical Examples of Formatting Data Labels

Now let's apply these concepts to solve some common charting problems.

Example 1: Cleaning Up a Pie Chart

Pie charts can easily become cluttered. Let's make one that's clean and easy to read.

1. Create a pie chart and add data labels. By default, it will likely show just the value.
2. Right-click on a label and choose Format Data Labels.
3. Under "Label Contains," uncheck Value and check Category Name and Percentage.
4. For the "Separator," choose (New Line). Now your labels cleanly show the category on one line and the percentage on the next.
5. Under "Label Position," select Outside End to move the labels out of the pie itself.
6. Finally, check the Show Leader Lines box. Now you have a professional-looking pie chart where every piece of information is clearly associated with its slice.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Example 2: Adding Custom Units with "Value From Cells"

What if your chart shows inventory levels, and you want each label to say "X units" instead of just "X"?

1. In your worksheet, create a new "helper" column next to your data. Let's say your inventory counts are in column B, starting in B2. In C2, you can enter the formula: =B2 & " units".
2. Drag this formula down for all your data points. You now have a column with your desired custom labels.
3. Add default data labels to your chart.
4. Go to the Format Data Labels pane for your labels, navigate to "Label Options," and under "Label Contains," check the box for Value From Cells.
5. A dialog box will pop up. Click and drag to select the helper column you just created (e.g., cells C2:C6). Click OK.
6. Finally, uncheck the default Value box. Your chart labels will now display the custom text from your helper column.

Example 3: Conditional Formatting for Data Labels

What if you only want to highlight labels that are above a certain target? For example, labeling only the sales months that exceeded $50,000. You can achieve this with a clever chart trick.

1. Create a new "helper" column in your worksheet next to your primary data. Call it "Target Labels".
2. Enter a formula that checks if your value meets the condition. If your sales data is in column B, the formula in this helper column would be: =IF(B2>50000, B2, NA()) This formula shows the sales value only if it's over $50,000, otherwise, it returns the #N/A error.
3. Now, click on your chart. In the Chart Design tab, click Select Data.
4. Click the Add button to add a new series. For the "Series values," select your new "Target Labels" helper column. Click OK. Your chart will now have a second set of columns or bars (likely in a new color) overlaid wherever the condition was met.
5. Right-click on one of the new bars from your "Target Labels" series and select Add Data Labels.
6. Finally, right-click that same new bar again, go to Format Data Series, and in the "Fill" options, choose No Fill. Now the duplicate bar is invisible, but its data label remains, perfectly highlighting only the values that met your criteria.

Final Thoughts

Mastering data labels moves you beyond basic chart creation and into compelling data storytelling. By carefully choosing what your labels show, where they're positioned, and how they’re formatted, you can guide your audience's attention and turn a confusing report into an insightful, professional-looking dashboard.

Of course, this level of manual formatting in Excel can get time-consuming, especially when you have to produce reports on a regular basis. At Graphed , we felt this pain, which is why we built an AI data analyst that automates the entire process. Instead of spending time clicking through format panes, you can simply tell our tool "Show me my sales by region on a pie chart with category and percentage labels" and a live, perfectly formatted dashboard is built for you in seconds. It connects to all your data sources so you can skip the manual CSV downloads and pivot tables for good.