How to Change Chart Labels in Excel

Staring at a generic "Series1" legend or a cryptic axis in your Excel chart can immediately reduce its impact. Clear labels are the difference between a chart that tells a powerful story and one that just creates confusion. This guide will walk you through exactly how to change every type of label in your Excel charts, from titles to individual data points, so your data is always presented with clarity and purpose.

First, What Are Excel Chart Labels?

Before diving into the "how," it's helpful to understand the different label types you can control within an Excel chart. Each one serves a specific purpose in making your data easy to understand.

Imagine a basic bar chart showing quarterly sales. Here are the common labels you'd see:

Chart Title: The main heading at the very top, like "Q1 Sales Performance." It tells the viewer the chart's overall subject.
Axis Titles: These describe the data along the horizontal (X-axis) and vertical (Y-axis). The Y-axis might be "Total Revenue ($)" and the X-axis "Sales Representative."
Legend Entries (Series Names): The legend is the key that identifies what different colors or patterns in your chart represent. If you were tracking multiple products, the legend entries might be "Product A," "Product B," and "Product C."
Data Labels: These are the specific values attached directly to your chart's data points (the bars, slices of a pie, or points on a line). For example, a data label could show "$45,210" directly above a sales representative's bar.
Category Labels: These appear on an axis and label the individual data points or groups of data you're charting, such as the names of the sales reps on the X-axis.

Knowing which label is which is the first step. Now, let's explore the different ways to edit them.

Method 1: Directly Editing Labels on the Chart

This is the fastest method for quick, one-off changes. It's perfect for when you're preparing a static report or a presentation and just need to make a quick text correction.

You can use this method for Chart Titles, Axis Titles, and sometimes Legend Entries.

Step-by-Step Instructions:

Click once on the chart element you want to edit. For instance, click the text of the Chart Title. You'll see a bounding box appear around it.
Wait a second, and then click again on the text inside the box. (Heads up: a quick double-click might open the Format pane on the right. If that happens, just single-click on the text again).
You should now see a cursor appear within the text, just as if you were editing text in a Word document or a standard Excel cell.
Type your new label text and press Enter or click outside the text box to finalize the change.

When to use this method: It’s great for quick cosmetic fixes or when you’re creating a simple, one-time chart that won't need to be updated. Its main drawback is that the labels are now static. If the source data that you'd want the label to be linked to ever changes, this manual label will not update automatically.

Method 2: Linking Labels to Cell Data for Dynamic Updates

This is the most powerful and flexible way to manage your chart labels, especially for dashboards and recurring reports. By linking a label to a specific cell in your worksheet, the label will automatically update whenever the value in that cell changes. This saves you from having to manually find and update your charts every time your data is refreshed.

Changing Chart Titles and Axis Titles Dynamically

Imagine your chart title is in cell A1, reading "Monthly Sales Report - January." Next month, when you update it to "Monthly Sales Report - February," you want your chart title to update too. Here's how to set that up:

Click once to select the chart title or axis title object on your chart. A box will appear around it.
Do not click into the text. Instead, with the object selected, click directly into the Formula Bar at the top of your worksheet.
Type the equals sign (=) into the formula bar.
Now, use your mouse to click on the cell that contains the text you want to use. For example, click on cell A1.
Press Enter.

Your chart title is now linked to cell A1. Any changes made to that cell will instantly reflect in your chart, making your reports much more efficient to manage.

Changing Legend Entries (Series Names)

Legend entries, like "Series1" or "Series2," are notorious for making charts look unfinished. These labels are pulled from the header row or column of your data source. Changing them is usually as simple as changing the text in that source cell.

The Simple Way: Edit the Source Data Cell

In most setups, all you have to do is locate the header cell for your data series. If your sales data for a product is in column B, the legend is likely pulling its name from cell B1. Just change the text in cell B1 from "Series1" to "Product A," and the legend on your chart will update immediately.

When You Need More Control: Using the "Select Data" Menu

Sometimes your chart isn't set up correctly, or you want the legend to pull from a different cell than the one Excel chose. In these cases, you can manually define the source for each legend entry.

Right-click on your chart and choose "Select Data..." from the context menu.
A dialog box titled "Select Data Source" will appear. On the left side, under "Legend Entries (Series)," you'll see the list of your data series.
Click on the series you want to edit (e.g., "Series1") and then click the "Edit" button above it.
A smaller "Edit Series" dialog box will now open. The top field is "Series name:". This is what you need to change.
You can either type a static name directly into this box (e.g., "North Region Sales") or, for a dynamic label, click the icon at the end of the field and select the cell in your worksheet that contains the name you want to use.
Click OK twice to close the windows. Your legend will now display the new, correct label.

This method gives you complete control over your data series names and ensures your charts are always referencing the correct information.

Method 3: Adding and Customizing Data Labels

Data labels help your audience see exact values without having to guess based on the axis lines. Excel gives you a deep level of control over what information these labels show and how they're formatted.

How to Add Data Labels to a Chart

Adding data labels is simple:

Select your chart.
Click the small green "+" icon (Chart Elements) that appears in the top-right corner of the chart.
In the menu that appears, check the box next to "Data Labels."
To change their position, click the small arrow next to "Data Labels" and choose from options like Center, Inside End, Outside End, etc., to find the best fit for your chart type.

How to Customize What Data Labels Display

This is where you can add real value to your charts. You can go beyond just showing the numerical value and include category names, series names, or even custom text from other cells.

First, add data labels using the method above.
Right-click on any of the new data labels on your chart and select "Format Data Labels..." from the menu.
The "Format Data Labels" pane will open on the right side of your screen. Click the icon that looks like a small chart (Label Options).
Under "Label Contains," you'll see a series of checkboxes. This is where the magic happens:
- Value From Cells: This incredibly useful option lets you select a range of cells to use as your labels. For example, if your chart shows sales numbers, you could use this to display a corresponding salesperson's name next to each bar. Select this, and Excel will prompt you to select the range containing that custom text.
- Series Name: Includes the name of the data series in each label.
- Category Name: Includes the name from the axis category (e.g., "Q1," "Q2") in each label.
- Value: Shows the numerical data point value (this is the default).
Use the "Separator" dropdown to choose how to display multiple pieces of information. For example, you could show the Category Name and the Value separated by a "New Line" to neatly stack them in the label.

Bonus Tip: Quick Formatting for Labels

Once your labels say what you want them to, you might want to adjust how they look. You don't always need to dive into the format pane for simple tweaks.

Select the Labels: Click once on any axis, title, legend, or data label to select all labels of that type. To format just a single data label, click once to select them all, then click a second time on the specific one you want to edit.
Use the Home Ribbon: With the labels selected, you can use the standard formatting tools on the Home tab. Change the font, font size, apply bold or italics, and change the font color just as you would for text in a cell.

This is an easy way to make important data pop or simply to align the chart's style with your company's branding.

Final Thoughts

This guide covered the key methods for changing chart labels in Excel, from directly typing a quick fix, to linking labels to cells for automated updates, to customizing data labels for maximum clarity. Mastering these techniques will help you create professional, easy-to-understand charts that effectively communicate your message every time.

Manually formatting Excel charts is part of a larger process of reporting that can consume hours every week. When you're tired of piecing together CSVs and endlessly tweaking reports, we built a tool to automate that entire workflow. With Graphed you simply connect your data sources (like Google Analytics, Shopify, or Salesforce), describe the dashboard you need in plain English - like "create a bar chart showing clicks and spend by campaign for last month" - and get a live, interactive dashboard in seconds. No more fussing with label alignment or data source ranges.