To change the order of series in an Excel area chart, select the chart and choose Chart Design > Select Data. Under Legend Entries (Series), select a series and use Move Up or Move Down; in a regular area chart, the series order also determines which filled areas appear in front of others.
What “change order” means in an area chart
An Excel chart contains two kinds of order that are easy to confuse: the order of the data series and the order of the categories along the horizontal axis. A series is one set of related values, such as sales for one product. Categories are the labels those values belong to, such as months or regions. The Select Data dialog lets you change a series’ place in the chart; it does not rearrange the categories themselves.
In an area chart, series order is especially visible because the chart draws filled regions. A series later in the plotting order can cover part of a series drawn earlier. In a stacked area chart, the order determines the vertical sequence of the stacked bands. Reordering does not change the values in the worksheet, but it can substantially change how a reader sees the chart.
Reorder series in Excel for Microsoft 365 on Windows
Use this method when you want to move one plotted series forward or backward without changing the worksheet’s data layout:
- Click the area chart. If the chart is selected, the contextual Chart Design tab appears on the ribbon.
- Choose Chart Design > Select Data.
- In the Select Data Source dialog, look under Legend Entries (Series). This list shows the plotted series in their current order.
- Click the series you want to reposition, then choose Move Up or Move Down.
- Repeat as needed, then click OK and inspect the chart and legend.
Move a series up or down one place at a time, checking the preview after each change if the chart is crowded. The dialog’s series list is the important control: changing the order of columns in the worksheet is not required. If you opened the dialog by mistake or do not see the chart tabs, click the chart once and try again.
How series order affects area charts
For a standard, non-stacked area chart, Excel fills each series down to the horizontal axis and draws the series in order. Earlier series are generally behind later ones, so an opaque area drawn later can obscure values and fill belonging to a series behind it. This is why a value can seem to vanish after you add another series even though it is still in the chart.
For example, imagine a chart with three product series: Basic, Plus, and Premium. If Basic is drawn first and Premium last, Premium can cover portions of Basic where their areas overlap. Moving Basic later may make more of its fill visible, but it may also obscure the other series. There is no universally correct order; choose one that makes the comparisons your audience needs easiest to see.
In a stacked area chart, the series are added vertically rather than simply overlapping from a shared baseline. The first series forms the bottom band, and subsequent series are stacked above it. Moving a series changes its position in the stack, which changes the shape and apparent thickness of the bands above it. The total at each category remains based on the same underlying values, but the visual story can be easier or harder to follow depending on which series sits at the bottom.
Series order is not category order
If the legend looks right but the months run in the wrong direction, changing the series order will not fix the problem. Category order is controlled separately. In a chart with a horizontal category axis, right-click that axis, choose Format Axis, and look for Categories in reverse order in the axis options. The exact options available can depend on the chart and axis type.
You can also check the source data if the category labels or values are arranged in an unexpected order. In the Select Data dialog, the Horizontal (Category) Axis Labels area lets you choose the cells used for those labels. Use this area to correct which labels appear, not the Move Up and Move Down controls for series. If the months are text values, Excel may use the row order supplied by the worksheet rather than interpreting them as a chronological date axis.
Changing the legend without changing the chart
For most standard charts, the legend reflects the series order, so moving a series changes both its plotting position and its place in the legend. Excel does not provide a general setting that independently rearranges legend entries while leaving the plotted series order untouched. That matters for area charts: moving a series just to make the legend look tidier may change which filled region is visible.
If you need a particular visual layering order but a different legend presentation, consider whether a custom legend is worth the extra maintenance. For example, you could remove the built-in legend and create labels with worksheet cells or text boxes. Those labels will not automatically behave exactly like a normal legend when series are added or renamed, so keep them synchronized with the chart data. Often the simpler solution is to choose a series order that works reasonably well for both the legend and the filled areas.
When changing the worksheet layout is appropriate
Reordering in Select Data changes the chart’s series sequence, not the physical position of the source columns or rows. This is usually the safest option when the worksheet layout is also used by formulas, tables, or other charts. Moving worksheet columns can affect other parts of a workbook, while changing a chart’s series order is limited to that chart.
There are cases where rearranging the source data is useful. If the chart is built from a simple contiguous range and you want the same order to be used when creating several new charts, arranging the source columns in the desired sequence can be convenient. However, existing charts may have their own series references and order. After changing the data layout, check each affected chart rather than assuming it updates exactly as intended.
For an Excel table, the series commonly correspond to the table’s value columns. You can still use Select Data to adjust a chart’s order without rearranging table fields. If the chart’s source is edited or rebuilt later, confirm that the intended order remains in place.
Common problems and useful checks
- A series appears to be missing: In a regular area chart, a later opaque fill may cover it. Move the covered series later in the order, or switch to a chart type that makes overlap easier to interpret.
- The legend changed but the chart is still confusing: The legend and plotting order are linked in ordinary charts. Review the filled areas after each move; do not judge the change from the legend alone.
- The wrong item is selected: In Select Data, select a name under Legend Entries (Series), not a cell range under the category labels. Use Edit if the series name or its value range is incorrect.
- The Move buttons are unavailable: Make sure a series is selected in the series list. Some specialized charts, including PivotCharts, may restrict what can be changed in Select Data; in those cases, adjust the relevant field arrangement or sort order in the PivotTable/PivotChart controls.
- The chart changes when data is refreshed: Charts based on dynamic or pivoted data may be rebuilt or updated from their source. Recheck the ordering after changing the source or refreshing a PivotChart.
After reordering, check that every area still represents the intended series and that the legend labels remain understandable. For stacked charts, compare the chart with the worksheet values at a few categories: the boundaries show cumulative totals, not each band’s independent value as a line would.
Choosing a chart type when order is not enough
If overlapping areas make the values hard to distinguish, moving the series may only trade one visibility problem for another. A line chart can be clearer when the goal is to compare trends for several series independently. Each line remains visible without one filled region masking another, although too many lines can still clutter the chart.
A stacked area chart is useful when the focus is how parts contribute to a changing total. It is less suitable when readers need to compare the exact values of every series, because only the bottom series shares a baseline; upper bands are judged between boundaries. A 100% stacked area chart emphasizes percentage composition, with each category normalized to 100%, rather than the absolute total. Changing order in either stacked type changes band placement, so make sure the chosen order supports the intended comparison.
Before changing chart types, ask what the viewer needs to compare: separate trends, total magnitude, or relative share. The answer often matters more than the order itself. If all three are important, separate charts or direct data labels may be more readable than forcing one area chart to communicate everything.
Excel on 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 ordering controls. Ribbon placement and dialog appearance can differ from Windows, but the goal is the same: reorder the chart’s series, not its category labels. Excel for the web has a more limited chart-editing interface in some cases. If you cannot find the series-order controls there, open the workbook in the desktop app and make the change in Select Data.
There is no dedicated keyboard shortcut that directly moves an area-chart series up or down. On Windows, use the ribbon path or right-click the chart to access chart commands where available; on Mac, use the Chart Design tab or the chart’s context menu. Keyboard shortcuts for selecting or navigating chart elements do not replace the series-order controls in the Select Data dialog.
Frequently Asked Questions
How do I change the order of areas in an Excel chart?
Select the chart, choose Chart Design > Select Data, select a series under Legend Entries (Series), and click Move Up or Move Down. Click OK to apply the new order.
Does moving a series change the data in my worksheet?
No. It changes the order in which that chart uses and displays its series. The worksheet values and the source cells are not rearranged by the Move Up and Move Down controls.
Why does one area cover another in Excel?
A standard area chart fills each series to the axis, and later series can be drawn over earlier ones. Reorder the series to change which fill is in front, or use a line or stacked chart if that better fits the comparison.
How do I reverse the months on the horizontal axis?
That is category order, not series order. Right-click the horizontal axis, choose Format Axis, and check the axis options for Categories in reverse order. You can also verify the order of the source labels.
Can I change only the legend order?
Usually not independently for a standard chart: the legend follows the series order. Reordering it can also alter how areas overlap or stack, so check the chart’s appearance after the change.
Related
- Conditional Formatting for Errors in Excel: How to Do It
- Contact List Excel Example and Setup Guide
- Excel Conditional Formatting Number Formats Explained
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Number Line Chart: Create and Format a Dot PlotExcel has no chart type named Number Line, but you can make one with an XY (Scatter) chart:…
- Excel Slicer Link to Different Pivot Tables: How It WorksYes. In Excel for Microsoft 365 on Windows, one slicer can filter multiple PivotTables when those PivotTables share…
- Power Pivot SUM Function: Syntax, Examples, and TipsIn Power Pivot, the DAX SUM function adds the numeric values in one column, returning a total that…
- Excel Double Stacked Column Chart: How to Build OneExcel does not have a chart type called a double stacked column chart, but you can create the…
- Excel Histogram: Why It Can Feel So FrustratingYes, Excel’s histogram can feel frustrating when it chooses unhelpful bins, hides important settings, or produces a chart…
- Google Sheets: How to Create and Customize a GraphTo create a graph in Google Sheets, select the cells containing your data, including their labels, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.