Excel Chart Series Order: Bring a Data Series to Front

Yes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data, select the series under Legend Entries (Series), and use the up or down arrow to change its plot order; for many overlapping 2-D charts, moving a series later in the list brings it visually in front. Excel does not provide a separate Bring to Front command for an individual data series.

What “bring a series to the front” means

A chart series is one set of related values, such as monthly sales for one product or one line in a graph. When series overlap, the order Excel draws them can determine which line, marker, column, or area is visible at the crossing or overlap. Changing the series order changes how Excel plots those data sets; it does not change the values in the worksheet.

This is different from bringing a whole chart object forward. If a chart is behind a picture or another shape, select the chart object and use the relevant Arrange commands on the Shape Format tab, such as Bring Forward. That changes the stacking order of objects on the worksheet. It does not rearrange the data series inside the chart.

For a typical overlapping 2-D line or column chart, Excel draws series according to their plot order, so a series plotted later can cover an earlier one. The exact visual result depends on the chart type and chart settings. If you are unsure which direction has the desired effect, move the series one place, inspect the chart, and undo or move it again if necessary.

Reorder a series in Excel for Windows

Use the Select Data Source dialog to change the order. The command works on the series list, so you do not have to rearrange the source rows or columns just to change what appears in front.

Click the chart to display the chart tabs on the ribbon.
Choose Chart Design > Select Data. In some window sizes, the ribbon may show the command in a condensed layout.
Under Legend Entries (Series), click the series you want to move. Check its name in the list so you do not select a different series by mistake.
Use the up or down arrow beside the list to change its position. Moving a series down makes it later in the list; in many overlapping 2-D charts, that makes it draw in front of series earlier in the list.
Choose OK and inspect the chart. If the series is still hidden or the visual effect is not what you expected, reopen Select Data and try the other direction.

The dialog also lets you edit a series’ name and its category and value ranges. Avoid changing those fields if your only goal is to change the plot order. If the chart’s legend is visible, reordering may change the legend sequence too, because the legend reflects series order.

How plot order affects different chart types

Series order is most useful when multiple data sets occupy the same chart space. In a line chart, one line may cross another, or a thick line may obscure a thinner one. In a chart with markers, the later series’ markers can cover markers beneath them. In an area chart, later plotted areas may conceal parts of earlier areas, depending on whether the chart is stacked and on the series values.

For overlapping columns, the series order can determine which column is visible when the series overlap. If the chart uses the default clustered layout, columns may sit beside one another rather than cover one another, so changing order might alter their sequence without producing a clear foreground effect. The Series Overlap setting, where available for the chart type, also affects how much the columns cover each other.

Some charts do not have a meaningful front-to-back relationship between series. A pie chart, for example, normally represents one series divided into slices; changing the order of slices is not the same as putting a series in front. In a stacked chart, order can change which component appears at the base or top of the stack. That may be important to the reading of the chart, but it is not simply a cosmetic layering adjustment.

Category-axis order is another separate setting. If your goal is to reverse the order of categories—for example, to put the first bar at the top of a horizontal bar chart—changing series order is usually the wrong control. The category axis has its own formatting options, including category order, which can be adjusted by formatting the axis.

Combo charts and secondary axes

A combination chart can mix chart types, such as columns for units sold and a line for a percentage. It can also place one series on a secondary axis. In these charts, changing the series list may not produce the same simple front-to-back result as it does in a basic line chart, because chart type and axis grouping can affect how the series are rendered.

To change the order, start with Chart Design > Select Data and move the selected series up or down. Then check the chart at its normal viewing size. If the line remains hidden behind columns, confirm that the series is actually formatted as a line and that its axis assignment is correct. Select the series, open Format Data Series, and review the series options rather than assuming that plot order alone controls its visibility.

When the line should remain easy to read, consider using markers, a more contrasting line color, or a different line width as well as changing order. A secondary axis can help when the measures use very different scales, but it should be labeled clearly: otherwise readers may mistake the line’s values for the column values.

Series order versus worksheet data order

Changing the series order in Select Data changes the chart’s series sequence; it does not sort the underlying table. This is useful when a chart’s source data has a logical order that you want to preserve, but the visual priority needs to differ. For example, a table might list products alphabetically while the chart should draw a highlighted “Other” series last so it is more visible.

You can also change the source layout by moving rows or columns, but that approach can affect other charts, formulas, or reports that use the same cells. If the chart is linked to a structured table or a frequently updated range, using the chart’s series controls is generally the less disruptive first option. Keep the legend and the chart’s visual order in mind: a change that improves visibility may also move the series’ legend entry.

If a chart is rebuilt or its source range is replaced, check the order again. A new series added to the chart may be appended to the list and therefore plotted last. That can be convenient when the new series is meant to stand out, or surprising when it covers an existing series.

Why the series may still look hidden

Reordering is not a fix for every visibility problem. Before repeatedly moving a series, check whether its values and formatting give Excel anything visible to draw. These common causes are worth checking:

The series has no usable values. Blank cells, text in a numeric range, or values outside the visible scale can make a series appear absent or incomplete.
Another series uses the same values. Two identical lines can sit directly on top of each other. Reordering may reveal one temporarily, but changing a line style or adding markers is often clearer.
The series is formatted invisibly. Check its line color, transparency, width, marker fill, and marker border in Format Data Series.
The axis scale hides the data. A series with values far smaller or larger than the other series may be compressed near an axis edge. Review the axis bounds and whether a secondary axis is appropriate.
The chart type does not overlap the way you expect. A clustered chart may place series beside one another, while a stacked chart combines them. Changing plot order cannot turn one arrangement into another.
The selection is the chart object, not the series. Clicking the chart’s outer border selects the whole chart. Click a plotted line, marker, or column to select a series, or use the series list in Select Data to avoid selecting the wrong element.

For identical or nearly identical lines, making the important series thicker or using a distinctive dash pattern can communicate the difference more reliably than relying only on which line is drawn last. If your chart will be printed in grayscale, use line styles or markers as well as color.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Mac, select the chart and look for Chart Design > Select Data, then use the series list and its reorder controls. Ribbon labels and dialog placement can vary slightly with the Excel version and window size, but the task is still to change the order in the chart’s data-source settings. The Windows instructions above do not depend on a Windows-only keyboard shortcut.

Excel for the web has a more limited chart-editing interface than the desktop application, and the available chart controls can vary. If you cannot find series reorder controls in the browser, open the workbook in the Excel desktop app and use Chart Design > Select Data. Save the workbook after changing it so the updated chart order is retained.

Frequently Asked Questions

Is there a Bring to Front button for an Excel chart series?
No. Bring Forward and Bring to Front commands apply to worksheet objects such as a chart, shape, or picture. To change the order of a series within a chart, use Chart Design > Select Data and reorder the series list.

Should I move the series up or down to make it visible?
For many overlapping 2-D charts, moving a series down makes it later in the plot order and therefore more likely to appear in front. Chart type and settings can affect the result, so inspect the chart after moving it and try the opposite direction if needed.

Does changing series order change my worksheet data?
No. Reordering a series in Select Data changes the chart’s series sequence, not the values or the order of the source cells. It may change the legend order because the legend follows the chart series.

How do I bring a line in front of columns in a combo chart?
Reorder the line series in Chart Design > Select Data, then check its chart type and axis assignment in Format Data Series. If it remains difficult to see, use a contrasting line, markers, or an appropriate secondary axis; series order alone may not determine the display in every combo chart.

Why does moving a series not reveal the data?
The series may contain blanks or text, be outside the axis scale, use invisible formatting, or exactly overlap another series. Check its source range, axis, line or marker formatting, and chart type before assuming that the plot order is the problem.

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.