Excel Chart Legend Missing Series? How to Fix It

If an Excel chart legend is missing a series, select the chart and open Chart Design > Select Data to check whether the series is listed and included in the chart’s source range. If it is listed, check the chart’s filter and legend settings; if it is absent, add it or correct the data range. A legend entry and a plotted series are related, but they are not the same thing, so identify which one is missing before changing the chart.

How Excel builds a chart legend

Excel creates chart series from the rows or columns in the chart’s source data. Each series normally has a name, such as a column heading, and a set of values. The legend uses the series names to identify the colored bars, lines, markers, or other data marks in the chart. For example, if a table has months in column A and sales for North and South in columns B and C, Excel may plot two series named North and South.

The chart’s data range determines which cells are available to the chart, but the series list in Select Data determines which of those rows or columns are actually plotted. A legend can therefore omit an item because the series was never included, was removed from the chart, was filtered out, or has a blank or unexpected name. In other cases the series is plotted, but the legend itself is hidden or its entry was removed.

Start by looking at the chart. If the data marks for the series are also missing, investigate the source range, series list, and filters. If the data marks are visible but the identifying text is absent, focus on the legend display and series name. This simple distinction prevents unnecessary changes to the worksheet data.

Restore a series through Select Data

In Excel for Microsoft 365 on Windows, click the chart, then choose Chart Design > Select Data. You can also right-click the chart and choose Select Data. The Select Data Source dialog shows the chart’s data range and a list of its legend entries (series).

Look under Legend Entries (Series). If the missing series is listed, select it and check that its name and values point to the intended cells.
If it is not listed, select Add. In the Edit Series dialog, set Series name to the cell containing the heading, or enter a text name, and set Series values to the cells containing the numbers.
Check that the values range contains data cells rather than the heading. For example, a heading in B1 and values in B2:B13 should use B1 for the name and B2:B13 for the values.
Select OK to close the Edit Series dialog, then OK again to apply the change to the chart.

Use the series list’s Edit and remove controls carefully: changing or removing a series affects the chart, not the worksheet’s underlying cells. If the chart is based on a structured Excel table, adding a new table column may expand the chart automatically, but check the series list rather than assuming it did. On Excel for Mac, select the chart and use the Chart Design tab’s Select Data command; dialog labels and layout can differ slightly by release. Excel for the web offers chart editing, but some detailed chart controls can be more limited than in the desktop app.

Check whether the legend or a legend item is hidden

If the series is plotted but there is no legend, turn the legend back on. Select the chart and choose Chart Design > Add Chart Element > Legend, then select a position such as Right, Top, Left, or Bottom. In many desktop versions, the green + Chart Elements button beside a selected chart also lets you enable Legend. The position matters: a legend can be clipped or hard to notice if the chart area is crowded, even though it is enabled.

If only one entry is missing while the other legend entries remain, the entry itself may have been deleted. In desktop Excel, select the legend, then select the individual legend entry and press Delete. This removes the entry from the legend; it is not the same as deleting the series from the chart. To restore it, the dependable approach is to remove and re-add the series through Select Data, or recreate the chart from its source range if the chart has become difficult to repair.

Check the chart’s filter as well. When a chart filter control is available, select the chart’s funnel-shaped Chart Filters button, inspect the Series list, tick the missing series, and choose Apply. A filtered-out series can disappear from both the plot and legend without being removed from the worksheet. The filter button is not available for every chart type or situation, so use Select Data if you cannot find it.

Verify the chart’s source range and layout

A source range that stops too early is one of the most common causes of a missing legend series. In Chart Design > Select Data, inspect the Chart data range. If the new column or row falls outside that range, extend the range to include the heading and values, or add the series individually. This often happens when someone appends a new month, product, or department beside a chart’s original data.

Also consider whether Excel interpreted the data in the wrong direction. In the Select Data Source dialog, choose Switch Row/Column to test whether rows should be treated as series instead of columns, or vice versa. For example, with years in rows and regions in columns, one orientation produces a series per region; switching orientation produces a series per year. Choose the arrangement that matches the story the chart is meant to show.

Headers help Excel assign useful legend names. If the heading cell is blank, the legend entry may be empty or generic. If a heading contains a formula that returns an empty string, Excel may have no visible text to display. Put a clear label in the heading cell, then check the series name in Select Data. Avoid selecting unrelated cells or an extra blank column as part of the chart range, since that can create an unwanted series or confuse the intended layout.

Look for hidden, filtered, or empty source data

A series can be correctly defined but appear to have vanished because its source values are hidden, filtered, blank, or nonnumeric. Check the worksheet for hidden rows or columns and for active table filters. By default, chart behavior for hidden data can differ from what a reader expects. To review it, open Chart Design > Select Data, choose Hidden and Empty Cells, and inspect the option for showing data in hidden rows and columns. The exact dialog presentation may vary between Excel releases.

Do not assume every blank-looking cell is truly empty. A formula may return an empty string, or a cell may contain text where a number is expected. If an entire series has no usable plotted values, Excel may not draw visible marks even when its series definition and legend label exist. Check a few source cells directly and confirm that the intended values are numbers. For charts that support it, the Hidden and Empty Cells settings also let you choose how empty cells are displayed, such as gaps or zeros; select the treatment that accurately represents the data.

Table filters can also change which rows feed a chart, and the chart’s own filters can hide whole series. These are separate checks: a worksheet filter affects visible records, while a chart filter can exclude a series from the chart. Clear filters temporarily to see whether the missing data returns, then restore only the filters needed for the intended view.

Consider chart type and series-name issues

Some chart types have structural limits. A pie chart, for example, represents parts of one data series, so it does not display a separate legend entry for every column as though each column were a separate series. If the goal is to compare multiple series, a column, bar, or line chart may be more appropriate. Likewise, a chart can have a series but show little or no visible mark if its values are outside the expected scale or overlap another series.

Combo charts can combine different chart types and, where appropriate, use a secondary axis. A series on a secondary axis is still a series; it should not be assumed to be missing merely because it uses a different scale. Open Select Data to confirm it is included, then use the chart’s formatting and axis settings to make it visible. Scatter charts also treat X and Y values differently from simple category-based charts, so verify that the series has the intended X values and Y values rather than relying on a basic column-chart layout.

Names can be confusing when a series name is a cell reference, a number, or a formula result. If the legend shows an unexpected label rather than no label, edit the series name to refer to the correct heading cell. A concise heading such as “Actual” or “Forecast” is easier to interpret than a long sentence, especially when the chart has several entries. Changing the legend text by changing the source heading may also affect other charts that use that same cell.

A quick troubleshooting order

When the cause is unclear, check in this order so you can isolate the problem without rebuilding the chart prematurely:

Is the whole legend missing? Enable it under Chart Design > Add Chart Element > Legend.
Are the series’ marks missing too? Inspect Chart Filters, Select Data, and the chart’s source range.
Is the series listed in Select Data? Edit its name or values if necessary; add it if it is absent.
Does the source contain valid data? Check hidden rows or columns, filters, blank cells, and numeric values.
Is the chart type suitable? Use a chart type that can represent the number and arrangement of series you need.
Did the chart update after the fix? Confirm that the legend label matches the plotted data and that no unintended series were added.

For a small chart with a complicated history, rebuilding it from a clean, correctly labeled range can be faster than diagnosing several old edits. Keep the original chart until the replacement has the right series, labels, and appearance. If the chart is part of a report or dashboard, check any linked objects or copied chart versions too; correcting one chart does not automatically repair separate charts elsewhere in the workbook.

Frequently Asked Questions

Why is a series in my Excel chart but not in the legend?
If its data marks are visible but its label is not, check whether the legend is enabled and whether an individual legend entry was deleted. Then inspect the series name in Chart Design > Select Data; a blank or incorrect heading can make the legend confusing.

How do I add a missing legend entry in Excel?
Select the chart, open Chart Design > Select Data, and choose Add under Legend Entries (Series). Set the series name to its heading cell and the series values to its data cells, then confirm the dialogs.

Why does my chart not include a new column of data?
The chart’s source range may not have expanded to include the new column. Check the range in Select Data and extend it, or add the new column as a series. If the data is in an Excel table, verify that the chart includes the added table column.

Can I show a series in the legend without plotting its data?
Excel’s standard chart legend is tied to chart series, so it is not a general-purpose list of independent labels. You can add a series to create a legend entry, but its values and chart type determine how it is plotted. For custom labels unrelated to plotted series, use text boxes or another deliberate chart annotation instead.

Why does a pie chart have only one series in its legend?
A pie chart displays one series divided into categories. Its legend typically identifies the categories or slices, not several independent series. To compare multiple series, choose a chart type designed for that comparison, such as a bar or column chart.

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.