How to Add a Second Data Label in Excel Chart

Adding a standard data label to an Excel chart is simple, but what if you need to show more than one piece of information for each data point? Displaying both the exact value and its percentage contribution on a single chart clears up ambiguity and saves your audience from doing mental math. This tutorial breaks down how to add a second, custom data label to your Excel charts, making your reports twice as useful.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother with a Second Data Label?

Dashboards and reports should be clear at a glance. When your team has to squint at an axis or flip back and forth between a chart and its data table, you’ve lost their attention. Combining information directly onto the chart provides immediate context and answers questions before they’re even asked.

Here are a few common scenarios where this technique is a lifesaver:

• Sales & Marketing Reports: Show the number of leads generated and the conversion rate for each marketing channel side-by-side on a bar chart.
• Budget Analysis: Display the actual amount spent and the percentage of the budget it represents for each category.
• Project Management: On a progress chart, show the number of tasks completed and the name of the person responsible.

Instead of creating two separate charts or cramming extra text into your presentation, a custom multi-part label keeps everything neat. The most reliable and flexible way to achieve this is by using a "helper column."

How to Add Custom Labels Using a Helper Column

This method works for almost any chart type in Excel (column, bar, line, etc.) and gives you total control over what your labels say. We'll walk through creating a visual that shows monthly sales figures and each month’s percentage of the total annual sales.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Set Up Your Data Table

First, get your source data organized. For the best results, format your data as an official Excel Table. This makes formulas easier to write and ensures your chart updates automatically when you add new data. To do this, just click anywhere in your data and press Ctrl + T.

Our sample data includes a list of months, the sales for that month, and a column calculating the percentage of the total for each month.

Here’s what our table, named tbl_Sales, looks like:

Step 2: Create Your "Helper Column" Formula

This is where the magic happens. A helper column's job is to combine the two pieces of information we want into a single text string that a chart label can display. We'll create a new column called "Chart Label."

We'll use a formula that joins the Sales value with the Percent of Total value. The key is to use the TEXT function to preserve the number formatting (like dollar signs, commas, and percentage signs). If you just join the cells, you’ll end up with raw numbers like 450000.10.

In the first cell of your new "Chart Label" column, type the following formula:

=TEXT([@Sales],"$#,##0") & " (" & TEXT([@Percent of Total],"0%") & ")"

Let's break that down:

• TEXT([@Sales],"$#,##0") formats the sales number from the current row as currency with a comma separator.
• & " (" & is the joining part. The ampersand (&) is Excel's operator for connecting text strings. We’re adding a space and an opening parenthesis.
• TEXT([@Percent of Total],"0%") formats the percentage value from the current row with a percent sign.
• & ")" adds the closing parenthesis at the end.

Since you’re using an Excel Table, the formula should automatically fill down the entire column. Your table will now look like this:

Step 3: Create Your Chart

Now, build your chart using the original data — not the helper column.

1. Select the columns you want to visualize (in our case, Month and Sales).
2. Go to the Insert tab and choose a chart type. A Clustered Column chart works well here.
3. Excel will generate your basic chart.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Connect the Helper Column to Your Data Labels

With your chart created, it's time to swap out the standard labels for your new custom ones.

1. Add Standard Labels First: Click on one of the bars in your chart to select the entire data series. Right-click and choose Add Data Labels. You’ll see the standard numeric values appear.
2. Open the Formatting Pane: Right-click on any of the new data labels and choose Format Data Labels.... This opens a "Format Data Labels" pane on the right side.
3. Choose "Value From Cells": Within the "Label Options" tab (the icon that looks like a small bar chart), you'll see "Label Contains." Check the box for Value From Cells.
4. Select Your Helper Column Data: A small dialog box will appear asking for the "Data Label Range." Click the arrow, then select all the cells in your "Chart Label" helper column (do not include the header). Click OK.
5. Clean Up the Labels: Back in the "Format Data Labels" pane, uncheck the original "Value" box and any others. Only the "Value From Cells" box should remain checked.

Your chart will instantly update, and all the data bars will now be displaying the perfectly formatted, two-part label you created in the helper column.

Advanced Tip: Adding a Line Break for Better Readability

Sometimes, putting everything on a single line can feel crowded, especially with long labels. You can force a line break within your helper column formula to stack the information vertically.

To do this, use Excel's CHAR(10) function, which represents a line break character.

Modify your helper column formula to look like this:

=TEXT([@Sales],"$#,##0") & CHAR(10) & TEXT([@Percent of Total],"(0%)")

Now, your label will appear with the sales value on the first line and the percentage directly below it, making it much cleaner and easier to read inside or above the bar.

What About Pie Charts? A Simpler Case

It's worth noting that certain chart types, like Pie Charts, come with more flexible built-in labeling options that may save you from creating a helper column.

If you're making a pie chart, create it as you normally would, add data labels, and open the "Format Data Labels" pane.

In the "Label Options" section, you'll see checkboxes for:

• Value: The numeric value of the slice.
• Category Name: The name of the slice from your data table.
• Percentage: The percentage representation of the slice.

You can check two or more of these boxes simultaneously. For example, checking both "Category Name" and "Percentage" will display both for each slice. You can even choose a separator (like a comma, space, or a new line) from the "Separator" dropdown list just below these options.

However, this simplicity comes with limitations. You can't combine custom text or perform complex number formatting like with a helper column and the TEXT function. For full control, the helper column method remains the best approach across all chart types.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Troubleshooting Common Issues

• My labels show the formula, not the results. This usually means the helper column cells were formatted as "Text" before you entered the formula. Fix it by changing the cell's formatting to "General" and re-entering the formula.
• Updating my source data doesn’t update my labels. This is often because you didn't select the whole dynamic range when you picked your "Value from Cells." The best way to prevent this is by formatting your source data as a formal Excel table from the start (Ctrl + T). The names will automatically adjust their own areas as they grow or shrink, and the chart will automatically update.
• The final labels are squashed together, difficult to read. This is a design issue. Try repositioning labels for better readability, and consider using a bigger chart type if necessary. Choose a clear font and resize appropriately from the "Format Your Data Set" pane.

Final Thoughts

Learning how to add a second (or even third) piece of information to your data labels using a helper column is one of the most practical skills you can master in Excel. It elevates your charts from simple visuals into info-rich tools that give your audience the context they need in one clear view.

Getting your hands dirty with formulas and formatting panes in Excel is powerful, but it's part of a manual process that consumes hours — especially when you're pulling data from multiple places. Our platform, Graphed, connects directly to your data sources like Google Analytics, Shopify, and Salesforce. Instead of wrestling with helper columns manually, you can simply ask, "Show me a bar chart of sessions by channel for the last 30 days, labeled with both the session count and the conversion rate," and sit back as the report builds itself. This allows analysts to focus on insights without struggling with formulas, enabling teams to take faster, informed actions and drive success.