Excel Legend Order Wrong on Combo Charts? Fix It

To fix a wrong legend order on an Excel combo chart, select the chart, choose Chart Design > Select Data, then select a series under Legend Entries (Series) and use the Move Up or Move Down controls. The legend follows the chart’s series order; changing a series’ chart type or putting it on a secondary axis does not, by itself, set a separate legend order.

Why a combo-chart legend can look out of order

A combo chart displays two or more data series using different chart types, such as columns for revenue and a line for margin. Excel still treats those plotted items as series. Their order in the Select Data dialog determines their order in the legend, even when the series use different chart types or axes.

This can seem surprising if you built the chart by choosing a combo-chart preset, changed a series to a line later, or reorganized the worksheet after creating the chart. The visible chart may emphasize the line, or a secondary axis may make one series easier to read, but neither choice means Excel will automatically put that series first in the legend. The legend is reflecting series order, not visual importance, axis assignment, or the order you expect readers to scan the chart.

Also distinguish the legend from the chart’s plotted appearance. Series order can affect how marks overlap or stack, so changing the order to fix the key may alter the plot. Check both the legend and the chart after making a change.

Reorder the series in Excel for Microsoft 365 on Windows

Use the chart’s data-selection dialog to change the order without rearranging the worksheet itself:

Click the combo chart to show the chart tabs on the ribbon.
Choose Chart Design > Select Data.
In the Select Data Source dialog, look under Legend Entries (Series). This list contains the plotted series and is the list that controls their legend order.
Select the series that needs to move, then use the up or down arrow controls beside the list to place it where you want it.
Choose OK and check the legend and plotted data. Repeat for other series if needed.

For example, suppose the list is Revenue, Units, and Margin, but you want the legend to read Revenue, Margin, and Units. Select Margin and move it above Units. Excel retains its existing line or column type and its axis assignment; the change is to series order.

If you are unsure which list item corresponds to a legend label, select a series in the dialog and use Edit to inspect its series name and data references. A series name may come from a worksheet cell, so the label you see in the legend need not be the same as the series’ position in the data table.

What the secondary axis does—and does not do

A secondary axis is commonly used in combo charts when series have different scales. For example, revenue might be shown as columns on the primary axis while a percentage margin is shown as a line on the secondary axis. The axis helps make both sets of values readable; it is not a separate control for legend order.

To change which axis a series uses, select that series and choose Chart Design > Change Chart Type. In the Combo options, use the Secondary Axis setting for the relevant series. This changes the scale on which Excel plots it, not its position in Legend Entries (Series). If the line appears on the wrong side of the legend after changing axes, use Select Data to reorder the series as a separate step.

Likewise, changing the chart type for a series does not create a second legend or automatically group all lines before all columns. If you want a deliberate sequence—such as Actual, Target, and Forecast—set that order in the series list, then confirm that each series still has the intended chart type and axis.

Check the visual effect before keeping a new order

Reordering is usually straightforward for a simple line-and-column chart, but it can affect visual layering. When series overlap, their draw order can influence which marks are easiest to see. In stacked charts, series order can also change the stack arrangement. A chart that reads correctly in its legend may therefore become harder to interpret after a reorder.

Before settling on the change, check these points:

Are any columns, lines, or markers obscured by another series?
Does a stacked series now appear in a less intuitive position?
Are the primary and secondary axis labels still clear about which values they describe?
Does the color or line style in the legend still match the corresponding marks in the chart?

If the requested legend sequence conflicts with a useful plotting sequence, consider whether the labels can be made clearer instead. For instance, a label such as Margin (%) can help readers understand a line on a secondary axis without relying on its position in the legend.

When the worksheet data order is involved

Excel often builds series from the rows or columns in the selected data range. If you create a chart from a table, changing the layout of that table or using Chart Design > Switch Row/Column can affect which items are plotted as series. However, changing the worksheet’s visible row order is not always the cleanest way to fix a chart: the chart may have its own stored series order, and moving worksheet data can affect formulas, other charts, or readers who rely on the table’s current layout.

For a chart-only adjustment, use Select Data and move the series there. If the dialog’s list does not match what you expect, inspect the Chart data range and the individual series references. Confirm that each series points to the intended values and name cell. This is especially useful when the chart was copied, built from a non-contiguous range, or edited after its source table changed.

Changing the series name is a separate task. In Select Data, choose a series and select Edit to update its Series name reference or entry. Renaming a series can make the legend more useful, but it does not move that entry. Conversely, moving a series does not change its name.

Special cases: PivotCharts, Mac, and Excel for the web

A PivotChart is connected to a PivotTable, so its fields and series order may be governed by the PivotTable layout. In that case, Select Data may offer fewer direct editing options or changes may be reset when the PivotTable is refreshed. Adjust the relevant field arrangement in the PivotTable or PivotChart field controls, then check the chart again. Do not assume a standard chart’s series-reordering instructions will behave identically for a PivotChart.

In Excel for Mac, select the chart and look for the chart design controls, including Select Data; the exact ribbon layout and dialog appearance can differ from Windows. The underlying idea is the same: change the plotted series order, not the axis setting. In Excel for the web, chart-editing controls can vary by chart and workbook. If you cannot find a series-order control or the change does not stick, open the workbook in the desktop version of Excel and make the adjustment there.

If the chart is protected or embedded in a protected sheet, editing may be restricted. Check the worksheet protection settings or ask the workbook owner for permission rather than trying to alter the chart’s source data as a workaround.

When a custom legend is a better solution

Excel does not provide a separate simple list for independently dragging standard legend entries into any order while leaving every other series property untouched. For most charts, reordering the series is the built-in method. If that causes an unacceptable change to stacking or overlap, a manually built legend can separate the display order from the plotted series order.

A manual legend can be made from colored shapes and text boxes placed beside the chart. It gives precise control over wording and sequence, but it is not automatically tied to the chart. If a series color changes, data is added, or the chart is resized, you may need to update the manual key yourself. For a chart that will be maintained by other people, document that dependency or prefer the standard legend when possible.

Another useful option is to simplify the legend rather than force a particular sequence. Clear series names, direct labels placed near a line, or a short explanatory note can make a combo chart easier to understand. Direct labels should not cover important data, and readers should still be able to distinguish series when the chart is printed or viewed without color.

Quick troubleshooting checklist

If the legend still appears wrong after moving entries, check the chart you actually edited and confirm that it is not a second chart or a PivotChart. Then reopen Select Data and verify the order in Legend Entries (Series), not the category-axis label list. A common mistake is changing the horizontal category labels, which affects labels such as months or product names rather than the legend.

Also confirm that the series names are distinct and that the legend is not being confused with labels placed directly on the chart. If a series is missing, check whether it is included in the chart data range; reordering cannot restore a series that is not plotted. After finalizing the order, review axis titles, data labels, colors, and the chart’s readability at its intended size.

Frequently Asked Questions

Can I drag legend entries into a new order?
Not as a normal way to reorder a standard Excel chart legend. Select the chart, open Chart Design > Select Data, and move the corresponding series in Legend Entries (Series). A manually created legend is an alternative if the plotted order must stay unchanged.

Why does the legend order not match the order of my worksheet rows?
The chart maintains a series list, and its current order may differ from the visible order of worksheet data. Check Select Data to see the order Excel is using. Reordering there changes the chart without requiring you to rearrange the source table.

Does putting a series on the secondary axis move it in the legend?
No. Secondary-axis assignment controls which value axis plots the series. Use the series-order controls in Select Data to change its legend position.

Will reordering series change my combo chart types?
Changing the order in Select Data is not the same as changing a series from a line to a column or assigning it to an axis. Still, series order can affect overlap or stacking, so inspect the chart after the change.

Why are the Move Up and Move Down controls unavailable?
The chart may be a PivotChart, the workbook or sheet may restrict editing, or the selected item may not be a regular chart series. Check the chart type and protection status. For a PivotChart, adjust the PivotTable or field layout that supplies its series.

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.