Excel Graph Legend: How to Add, Format, and Fix It

Charts & pivot tables · Updated November 17, 2026

An Excel graph legend explains which data series—or, in some chart types, which categories—are represented by the chart’s colors, patterns, or markers. To add one in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add Chart Element > Legend and pick a position.

What an Excel graph legend shows

A legend is the chart’s key: it pairs a label with the visual style used for related data. In a line chart, for example, a blue line might represent 2024 sales and an orange line might represent 2025 sales. The legend lets readers identify each line without guessing from color alone. In a column chart, the same idea applies to colored columns or groups of columns.

Excel generally gets legend labels from the names of the chart’s data series. When a chart uses column headings as series names, those headings usually appear in the legend. If the headings are missing or unclear, Excel may use generic labels such as Series 1. In pie and doughnut charts, the legend commonly identifies slices by category instead; the chart’s setup and selected data determine what appears.

A legend is not the same as a chart title, axis title, or data label. The chart title describes the overall subject, an axis title explains a scale, and data labels show values or category names near individual points. A legend identifies what a visual series or slice represents.

How to add or remove a legend

In Excel for Microsoft 365 on Windows, use the ribbon to add a legend:

  1. Select the chart so the chart-specific tabs appear.
  2. Choose Chart Design > Add Chart Element > Legend.
  3. Choose a placement such as Right, Top, Left, or Bottom.

You can also select the chart and use the Chart Elements button (the plus sign beside the chart) to turn Legend on or off. This is a quick way to show or hide it, although the ribbon gives you the available placement choices. To remove a legend, turn off Legend with that button, or select the legend itself and press Delete. Deleting the legend does not delete the chart’s data.

On Excel for Mac, select the chart and look for the Chart Design tab and its Add Chart Element controls; the exact ribbon arrangement can vary by release. The basic operation is the same: add the legend, then choose its position. In Excel for the web, chart editing controls can be more limited or arranged differently, so the desktop ribbon steps may not match exactly.

How to change legend names

If the legend says Series 1 or displays an unhelpful heading, change the series name rather than manually covering the legend text. Select the chart, then choose Chart Design > Select Data. In the Select Data Source dialog, select the series under Legend Entries (Series) and choose Edit. In the Series name box, you can enter a clearer name or refer to a worksheet cell containing that name. Confirm the dialog to update the chart.

For many charts, the simplest approach is to edit the source data’s column or row heading. If the chart uses that heading as its series name, the legend updates when the chart recognizes the changed source. For example, if a table has headings “Q1” and “Q2,” changing them to “First quarter” and “Second quarter” can make the legend more informative. If changing the heading does not update the legend, use Select Data to check which cells the chart is using.

To change which series appear, use the same Select Data Source dialog. You can add or remove a series or adjust its source range. Be careful when selecting ranges: including a total row as another series can create an extra legend entry and distort the chart. A name should identify the data clearly without being so long that it consumes space or wraps awkwardly.

Choosing a position and formatting the legend

Legend position affects how easily readers connect labels to the data and how much room the chart has for its plot. Right is a familiar choice for charts with a few series, while Bottom can work well when labels are short and the chart is wider than it is tall. Top may suit a compact chart, and Left can be useful when it keeps labels near the relevant data without crowding the right edge.

After selecting the legend, open its formatting controls to adjust details such as text appearance, fill, border, and placement. Depending on the selected chart element, you can open the Format Legend pane from the chart’s formatting options or by right-clicking the legend and choosing Format Legend. The available settings depend on the chart and Excel version. If you want the legend outside the plot area, choose a standard position such as Right or Bottom; Excel can resize the plot area to make room.

  • Keep the legend near the chart it explains, especially if a worksheet contains several charts.
  • Use distinct, readable series names and avoid relying on similar shades to tell entries apart.
  • Check the chart at its final size: a legend that fits on a large screen may become cramped when printed or placed in a report.

For a chart with many series, moving the legend to the bottom can create a long row or several lines of labels. Consider a larger chart, shorter names, or fewer displayed series instead of shrinking the legend text until it is difficult to read. A legend should help interpret the graph, not compete with it.

Legend versus data labels and category labels

A common source of confusion is expecting the legend to name every point. In a line chart with one series for each year, the legend usually names the years, while the horizontal axis names categories such as months. If the reader needs to see a particular value, add data labels rather than expecting the legend to provide it. Select the chart and choose Chart Design > Add Chart Element > Data Labels to see available label placements.

Pie charts work differently from a typical line chart because each slice is a category within one data series. Their legend can list category names, such as product types, with a matching color for each slice. If the goal is to show names and values directly beside the slices, data labels may be clearer. You can add labels through Add Chart Element and choose which label details to display in the formatting options.

Neither a legend nor a data label automatically makes a chart understandable. If a chart has many nearly identical categories or series, readers may struggle even when every item is named. A simpler chart, clearer category names, or a focused selection of data may communicate the point better.

How legends behave in different chart types

Column, bar, line, area, and many combo charts use legends to distinguish data series. A chart plotting monthly revenue for three regions, for instance, can use one colored series per region and a three-item legend. In a scatter chart, each series is typically distinguished by a marker style or color, with its series name in the legend.

Pie and doughnut charts commonly use legend entries for individual slices, which correspond to categories. A chart with only one series may still have a legend, but it can add little value if the chart already makes the category clear. Some chart types or layouts do not use a conventional legend in the same way; a histogram, for example, groups values into bins, so axis labels and chart labels may be more relevant than a series key. The chart type and data arrangement affect what Excel offers and displays.

When Excel plots the data in the wrong direction, the legend can look wrong even though its formatting is fine. In Chart Design > Switch Row/Column, you can change whether rows or columns form the series. Review the chart’s axes and legend together after switching: this changes how Excel groups the source data, not merely the appearance of the key.

Common legend problems and fixes

If a legend is missing, select the chart and add Legend from Chart Design > Add Chart Element. If the legend exists but is outside the visible worksheet area or clipped in a report, select it and choose a different position, or enlarge the chart. Resizing the chart can also give the plot and labels more room.

If the legend shows generic or incorrect names, check the source headings and the series definitions in Select Data. Confirm that each series name points to the intended heading and that the chart includes the correct cells. If the colors do not seem to match the expected data, select the chart series and inspect the source range and series order; a legend entry’s color represents its series or category, not necessarily a fixed meaning across every chart.

If labels overlap or the legend is too crowded, try these remedies:

  • Move the legend to another edge of the chart, such as Bottom or Right.
  • Shorten source headings while keeping them meaningful.
  • Make the chart larger or show fewer series at once.
  • Use direct data labels when readers need to identify individual points.

Also check whether a chart is selected when you look for Chart Design. That tab appears when a chart is active; clicking a worksheet cell instead can hide the chart-specific controls. If you cannot select the legend easily, click the chart first and use the chart element controls to turn the legend off and back on, or select it through the chart’s formatting options.

Frequently Asked Questions

What is a legend in an Excel graph?
A legend is a key that connects chart colors, lines, markers, or slice colors with the series or categories they represent. Its wording usually comes from the chart’s source data or series settings.

How do I add a legend to an Excel chart?
Select the chart and choose Chart Design > Add Chart Element > Legend, then select a position. On Windows, the plus-sign Chart Elements button beside the chart is another way to turn the legend on.

How do I rename Series 1 in an Excel legend?
Choose Chart Design > Select Data, select Series 1 under Legend Entries (Series), and choose Edit. Enter a clearer series name or select a cell containing the desired name.

Can I put the legend inside or below the chart?
Choose a position from Chart Design > Add Chart Element > Legend. Available positions depend on the chart and Excel version; moving the legend can change the space available for the plot area.

Why does my Excel chart legend show the wrong labels?
The chart may be using the wrong heading cells, or Excel may be treating rows and columns as the opposite series arrangement you intended. Check the series names in Select Data and, if needed, use Switch Row/Column to change how the source data is grouped.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.