How to add a legend title to a box plot in Excel
Excel does not have a built-in box plot chart type, so you create one using a stacked column chart with error bars. Once you have that chart, adding a legend title requires you to edit the chart's legend properties directly — there is no single menu option that does it automatically. The process takes three steps: right-click the legend itself, select "Format Legend", and type your title in the Label Options panel.
The reason this is not obvious is that Excel treats the legend title as a separate object from the legend entries. You are not labeling the data series; you are labeling the entire legend box. This matters because it means the title appears above all the series names, not next to individual ones.
Key Takeaways
- Box plots in Excel are built from stacked column charts, and their legends work the same way as any other chart legend.
- To add a legend title, right-click the legend, choose "Format Legend", and enter text in the Label Options section.
- The legend title appears above all series names and applies to the entire legend, not to individual data series.
- If your legend title does not appear after you type it, make sure the "Show Legend Entry" checkbox is checked in the same panel.
The three-step process for adding a legend title
Start with your box plot chart already created in Excel. Click anywhere on the chart to select it, then click specifically on the legend (the box showing your series names, usually on the right side of the chart). The legend will show selection handles around it.
Right-click the legend and select "Format Legend" from the menu. A panel will open on the right side of your screen. Look for the "Label Options" section — you may need to scroll down to find it. In that section, there is a text field labeled "Legend Entry Label" or straightforward a blank box where you can type. Type the title you want your legend to have, such as "Box Plot Components" or "Data Series". Press Enter or click outside the field to explore the change.
If the title does not appear, check that the "Show Legend Entry" checkbox is marked. Some versions of Excel hide the legend title by default even after you type one. Once you see the title appear above your legend entries, you can close the Format Legend panel by clicking elsewhere on the chart or pressing Escape.
Why box plots need legend titles in the first place
A box plot shows five numbers for each data series: the minimum, the first quartile, the median, the third quartile, and the maximum. In Excel, you build this using stacked columns where each segment represents one of those values. The legend then lists what each color or segment means — "Minimum", "Q1", "Median", "Q3", "Maximum", for example.
Without a legend title, readers see only the individual segment labels. A legend title like "Statistical Measures" or "Quartile Breakdown" tells them at a glance what the entire legend is describing. This is especially useful in reports or presentations where the chart appears without surrounding text to explain it.
Positioning and formatting the legend title
By default, Excel places the legend title directly above the legend entries. You cannot move the title to a different location without moving the entire legend. If you want the legend in a different spot — say, at the bottom of the chart instead of the right — right-click the legend again, select "Format Legend", and look for the "Legend Position" option. Choose your preferred location, and the title will move with it.
To change how the title looks, right-click it specifically (not the whole legend) and select "Format Legend Title". You can then adjust the font, size, color, and alignment. This is separate from formatting the legend entries themselves, so you can make the title bold or a different color to make it stand out.
Common problems when adding legend titles
The most frequent issue is that you right-click the legend entries instead of the legend box itself. The legend box is the entire rectangular area; the entries are the individual lines or symbols inside it. If you right-click an entry, you will get options to format that specific series, not the legend as a whole. Click on the border or background of the legend box to select the whole legend.
Another common problem is typing the title but not seeing it appear. This usually means the "Show Legend Entry" option is unchecked. Go back to Format Legend, find Label Options, and make sure that checkbox is marked. If it is already marked and the title still does not show, try clicking elsewhere on the chart to deselect and then reselect the legend to refresh the view.
If your legend title appears but looks cut off or misaligned, you may need to resize the legend box itself. Click and drag the corner handles of the legend to make it wider or taller, giving the title more room to display properly.
When to use a legend title versus other labeling methods
A legend title works well when your chart is part of a larger document and you want the legend to be self-explanatory. It is less necessary if you have a caption below the chart or text in the surrounding paragraph that already explains what the legend shows.
For presentations or dashboards where the chart stands alone, a legend title is almost always worth adding. It takes only a few seconds and makes the chart clearer to anyone viewing it without additional context. If your legend is very long or complex, a title becomes even more important because it signals to the reader that they need to understand the legend to read the chart correctly.
Frequently Asked Questions
Can I have different legend titles for different data series?
No. The legend title applies to the entire legend, not to individual series. If you need to label specific series differently, you would need to create separate charts or use text boxes positioned near individual legend entries.
What if I want to remove the legend title after adding it?
Right-click the legend, select "Format Legend", find the Label Options section, and delete the text from the title field. Leave it blank and press Enter. The legend title will disappear.
Does the legend title change if I change the data in my chart?
No. The legend title is a separate label that you type manually. It does not update automatically when your data changes. If you rename your data series, you may want to update the legend title to match, but Excel will not do this for you.
Can I use special characters or line breaks in a legend title?
You can use most special characters, but line breaks within a single legend title field are not supported in the standard Format Legend dialog. If you need multiple lines, consider using a shorter title or adding a text box near the legend instead.