How to Add Box Plot Legend Titles in Excel

Box plots are one of Excel's more powerful statistical chart types, giving you a compact visual summary of data distribution — median, quartiles, outliers, and spread all in one glance. But like many chart types, the default output is often stripped of context. Legend titles, in particular, tend to be missing or generic. Here's how that actually works — and why getting it right depends on more than a single answer.

What a Box Plot Legend Actually Shows

Before diving into the steps, it helps to understand what the legend is doing in a box plot. In Excel's Box and Whisker chart (available in Excel 2016 and later through the Insert > Charts menu), the legend displays the data series names — the labels that correspond to each box in the chart.

If you've plotted multiple categories (say, sales by region across four regions), the legend identifies which box belongs to which category. By default, Excel pulls series names from your data headers. If your headers are blank or generic ("Series 1," "Column A"), your legend will be just as unhelpful.

Step 1: Rename the Data Series for an Accurate Legend

The most reliable way to control what appears in your legend is to edit the source data labels directly in your spreadsheet. Excel's chart engine reads column or row headers as series names.

• If your data is in columns, the header row (row 1) feeds the legend labels.
• If your data is in rows, the leftmost column often serves as the series identifier.

Change the header text in your worksheet, and the legend updates automatically when you refresh or look at the chart. This is the cleanest approach because it keeps your data and your chart in sync.

Step 2: Edit Series Names Through the "Select Data" Dialog

If you don't want to rename your worksheet headers — or if the chart is pulling from a named range — you can rename series directly inside Excel:

1. Click on the chart to select it.
2. Go to Chart Design (or "Design" tab in older versions) in the ribbon.
3. Click Select Data.
4. In the "Legend Entries (Series)" panel, select the series you want to rename.
5. Click Edit.
6. In the Series name field, either type a new name directly or reference a cell that contains the label you want.
7. Click OK, then OK again.

This updates the legend entry without touching your underlying data. It's particularly useful when your source data is shared or structured in a way that you can't easily rename.

Step 3: Adding or Editing the Legend Title Itself

Here's where many users get stuck: Excel does not natively support a separate "legend title" field the way it supports axis titles. The legend in Excel charts shows series names, but there's no dedicated text box built into the legend for a title label above those entries.

Your options to work around this:

• Use a text box: Insert a text box (Insert > Text Box) and position it above or beside the legend manually. This gives you visual flexibility but isn't linked to the chart data — it's a floating object.
• Rename the chart title to include context: If your chart has only one data series, the chart title itself often performs the job of a legend.
• Use axis titles instead: For box plots comparing categories, the horizontal axis title (added via Chart Design > Add Chart Element > Axis Titles) can label what the boxes represent, which sometimes removes the need for a legend title entirely.

📊 How Different Setups Affect Your Options

Variables That Change the Right Approach

Excel version matters. Box and Whisker charts were introduced in Excel 2016 as part of the statistical chart library. In Excel 2013 and earlier, box plots were built manually using stacked bar charts, and the legend behavior follows entirely different rules — series names map to stacked components, not categories.

Data layout matters. Whether your data runs in columns or rows changes which cells Excel reads for series labels. A common source of legend confusion is simply that Excel is reading the wrong range.

Number of series matters. With a single-series box plot, the legend often adds no value and can be hidden entirely (click the legend, press Delete). With five or six series representing different groups, a clear legend becomes essential for readability. 🎯

Chart destination matters. If the chart is destined for a PowerPoint deck or a printed report, you may have more flexibility with manual text boxes. If it's staying in Excel and needs to stay dynamic — updating as data changes — then keeping labels tied to cell references is the more stable path.

When the Legend Isn't the Right Solution

Some users realize mid-process that what they actually need isn't a legend title but better data labels, axis labels, or simply a more descriptive chart title. Excel gives you control over all of these through the Chart Elements button (the + icon that appears when you click the chart on Windows) or through the Chart Design tab.

For box plots specifically, the whiskers and median line are not individually labeled by default. If your audience needs to understand what those elements mean, adding a legend key explanation as a text annotation — outside the native legend — is often cleaner than trying to force that information into the series name.

What the right configuration looks like depends on your data structure, how many series you're comparing, which version of Excel you're running, and what the chart ultimately needs to communicate to its audience — factors that only your specific spreadsheet and use case can answer.