To change the series order in an Excel stacked bar chart, select the chart and choose Chart Design > Select Data. Under Legend Entries (Series), select a series and use the up or down arrow to move it; the new order changes how the series stack and appear in the legend.
What series order means in a stacked bar chart
A stacked bar chart uses each series as one segment of a bar. For example, a chart showing product sales by region might have a separate series for each product. Excel stacks those series’ values within each region’s bar, so the order of the series determines the sequence of segments. It also determines the order of the series names in the legend.
Changing this order does not change the underlying values, categories, or totals. It changes how the same values are arranged in the chart. That distinction matters because readers may find a particular segment easier to compare when it is consistently placed at the start or end of each bar.
In Excel, the series list in the Select Data Source dialog is the practical control for this order. The visual direction of the stack can depend on whether the chart is a bar chart or a column chart and on axis settings, so check the result in the chart rather than assuming that moving a series up always puts it on a particular physical side.
Change the order in Excel for Microsoft 365 on Windows
- Click the stacked bar chart to select it. If the chart is embedded on a worksheet, make sure you have selected the chart rather than a data cell.
- Open the Chart Design tab on the ribbon and choose Select Data. You can also right-click the chart and choose Select Data.
- In the Select Data Source dialog, find Legend Entries (Series). Click the series you want to reposition.
- Use the up or down arrow beside the series list to move the selected series. Repeat as needed to put the series in the desired sequence.
- Choose OK, then check both the stacked bars and the legend. Reopen Select Data if the result is not right and adjust the order again.
The change applies to the chart as a whole. You cannot use this control to put a series in one order for one category and a different order for another category. Each series keeps its identity across all the bars.
Example: put a key segment at the end of each stack
Suppose a chart has three series: Basic, Plus, and Premium, with one bar for each quarter. If Premium is the value readers most need to compare, you may want its segment at the same end of every stack. In Select Data, select Premium and move it to the appropriate position in the series list. Excel redraws the stacks and updates the legend to match.
Check the chart after moving it: on a horizontal stacked bar, the segments extend along the horizontal direction, while a stacked column extends vertically. The series order is controlled in the same dialog, but how the ordered segments appear on screen can be affected by the chart’s orientation and axis direction. If the segment lands at the opposite end from the one you intended, move it to the other end of the list or review the relevant axis settings.
For a meaningful legend, consider arranging the series in a logical order, such as low to high, oldest to newest, or the order used in a report. A visually convenient stack is not always a good reason to make the legend sequence confusing. The best choice makes the bars and the key easy to interpret together.
Series order is different from category order
A common source of confusion is changing the series order when the actual problem is the order of the bars. In the example above, Basic, Plus, and Premium are series; the quarters are categories. Moving a series changes the segments within every bar. It does not move Q1 ahead of Q2 or rearrange product names used as categories.
For a horizontal bar chart, category labels appear on the vertical axis. To change their visual order, right-click the category axis, choose Format Axis, and review Categories in reverse order. Turning that setting on or off reverses the category display; it does not change the series sequence or the data source. The available axis options can depend on the selected axis and chart type.
If the labels themselves are in an unwanted order, you can also sort or rearrange the source table. That changes the category order supplied to the chart, and may affect other charts or formulas that use the same cells. Use the axis setting when you only want to change how this chart displays categories; change the table when the source order itself should change.
Series order is different from switching rows and columns
The Switch Row/Column command changes which data groups Excel treats as series and which it treats as categories. It is not simply a move-up or move-down control. For instance, a table with quarters in rows and products in columns may produce products as series; switching rows and columns can instead make the quarters the series.
Use Chart Design > Switch Row/Column only when the chart is grouping the data in the wrong direction. If the chart already has the correct series and categories but the segments are in the wrong sequence, use Select Data and move the series. After switching, the chart may have different legend entries and category labels, so inspect it before keeping the change.
When the order keeps changing or will not move
If Excel does not seem to retain the order you selected, first confirm that you are editing the intended chart and using the arrows in the Legend Entries (Series) list. The category labels are shown in a separate part of the dialog; selecting or editing those will not reorder the series.
- The chart is based on a table: Reordering the series in Select Data changes the chart’s order, but editing or rebuilding the chart can make you revisit that setting. Check the finished chart after changing its source.
- You selected a chart filter: The chart filter can hide or show series, but it is not the same as the series-order controls. Use Select Data when you need to rearrange the visible series sequence.
- The chart is a 100% stacked chart: Its segments represent each category’s proportion of the total rather than the raw totals. Series order still controls segment sequence, but it does not change the percentages or the underlying values.
- The chart type is not stacked: In a clustered bar chart, series appear beside one another instead of as segments in a stack. Reordering still affects series and legend sequence, but it will not create a stacked appearance.
If you cannot select a series in the dialog, click its name in the series list rather than clicking a segment in the chart. If the data is arranged unexpectedly, inspect the chart’s data range and confirm which rows or columns Excel has assigned as series.
Excel for Mac and Excel for the web
In Excel for Mac, select the chart and use the chart design controls to open Select Data, then reorder entries in Legend Entries (Series) with the available arrows. Ribbon layout can differ slightly from Windows, but the series-list approach is the same. You can also use the chart’s contextual controls when available.
Excel for the web has chart editing features, but the ribbon and available dialog options can differ from the desktop application and may vary as the web app is updated. Select the chart and look for its chart design or data controls. If the web interface does not expose the series-order buttons for your chart, open the workbook in the desktop Excel app and use Chart Design > Select Data. The chart’s data and formatting remain in the workbook when you open it in the desktop app.
Choosing a useful order
There is no universally correct series order. Choose one that supports the point the chart is meant to communicate and stays consistent with the legend, source table, and any related charts. Since stacked charts make it easiest to compare the segment at a shared baseline, the first or last segment may receive more visual attention than segments in the middle.
- Put a category that readers need to find quickly at a consistent, easy-to-see end of the stack.
- Keep a natural sequence, such as stages in a process or age groups from youngest to oldest, unless the chart’s purpose calls for another order.
- Use the same series order across related charts so viewers can compare them without relearning the legend.
- For many series, consider whether a stacked chart is still readable. A long legend and many thin segments can make comparisons difficult even when the order is tidy.
Remember that segment order alone does not make all values equally easy to compare. A stacked chart is useful for showing totals and composition, but segments that do not share a common starting point are harder to compare precisely across categories. If the main task is comparing individual series values, a clustered bar chart or a table may communicate them more clearly.
Frequently Asked Questions
How do I reverse the order of a stacked bar chart in Excel?
To reverse the series sequence, select the chart, choose Chart Design > Select Data, and move the entries in Legend Entries (Series) using the up and down arrows. If you mean reversing the order of the category labels, change the category axis setting instead.
Why does the legend change when I reorder a stacked bar chart?
The legend follows the chart’s series order. Moving a series in Select Data changes both its position in the stack sequence and its place in the legend. This is expected; Excel does not provide a separate series-order list for the legend and the stack in this dialog.
Can I change the order of just one bar’s segments?
No. The series order applies across the whole chart, so the same sequence is used for every category. To show different groupings, you would need to redesign the source data or create separate charts rather than assign an independent order to one bar.
How do I move a bar to the top or bottom?
If you mean moving a category bar up or down in a horizontal chart, change the category order, usually through Format Axis and Categories in reverse order, or rearrange the source categories. If you mean moving a segment within every stack, reorder its series in Select Data.
Does changing series order change the totals?
No. Reordering changes the display sequence, not the values being added. In a regular stacked chart the totals remain based on the same source values; in a 100% stacked chart the percentages are also based on those values, though segment positions change.
Related
- Excel Shortcut to Insert an Entire Row
- Excel Unmerge Cells Shortcut: Steps, Limits, and Fixes
- Excel Shortcut for Selecting a Column in One Step
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Waterfall Chart Split Bar: How to Show ComponentsExcel’s built-in Waterfall chart cannot split one bar into stacked segments. To show what makes up a change,…
- Excel Waterfall Chart: Show a Total at the EndTo show a final total in an Excel waterfall chart, select the last bar, right-click it, and choose…
- Excel Line Chart With X and Y Values: Setup and TipsTo make an Excel line chart, put your x values in one column and the matching y values…
- Excel Bubble Chart Axis Settings: How to Set the ScalesIn Excel for Microsoft 365 on Windows, select an axis in the bubble chart, right-click it, and choose…
- Excel Waterfall Charts: How to Create and Format ThemIn Microsoft Excel for Microsoft 365, select a table of categories and values, then choose Insert > Insert…
- Excel Pivot Tables With Multiple Data Sources: How-ToYes. In Excel for Microsoft 365 on Windows, you can build one PivotTable from multiple tables by adding…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.