How to Flip a Stacked Bar Chart in Excel: Axes and Series

To flip a stacked bar chart in Excel, first decide what you want to change: use Chart Design > Change Chart Type to turn horizontal bars into vertical columns, Format Axis to reverse category order, or Chart Design > Switch Row/Column to swap categories and series. These changes affect different parts of the chart, so choose the option that matches the result you want.

The steps below are for Excel for Microsoft 365 on Windows. A stacked bar chart has horizontal bars, while a stacked column chart has vertical columns. People often use “flip” to mean either orientation change, reversing which category appears first, or changing the order of the colored segments. You can make any of these adjustments without rebuilding the chart, although checking the data layout first helps avoid an unexpected result.

What You’ll Need

An Excel workbook with the data and chart you want to change. Save a copy first if the chart is important or difficult to recreate.
A chart with two or more data series. A stacked chart displays each series as a segment of a category’s total.
Clear category labels and series headings in the source data. For example, categories might be regions and series might be product types.

Step-by-Step

Select the chart and identify the kind of flip. Click once on the chart’s border so the chart is selected and the Chart Design tab appears. Look at the chart before changing it. If you want the bars to run vertically, change the chart type to a stacked column chart. If you want the same bars in a different top-to-bottom order, reverse the category axis. If the legend items should become categories, switch rows and columns. If only the colored segment order is wrong, reorder the series instead. These are separate operations; switching one does not necessarily do the others.
Change horizontal stacked bars to vertical stacked columns. With the chart selected, choose Chart Design > Change Chart Type. In the dialog, choose Bar in the chart-type list to see horizontal options, or Column to see vertical options. Select Stacked Bar to keep horizontal bars, or Stacked Column to make vertical columns. Do not choose 100% Stacked unless you specifically want every category normalized to 100 percent; that changes what the displayed values mean. Click OK to apply the chosen type. Your existing series, colors, and data are usually retained, though the legend or axis labels may need adjustment.
Reverse the category order without changing orientation. Click a category label on the chart’s vertical axis. In a horizontal bar chart, these are the labels beside the bars, not the numeric scale along the bottom. Right-click the axis and choose Format Axis. In the Format Axis pane, open Axis Options and select Categories in reverse order. The first category in the source data will now appear at the opposite end of the list. This is useful when you want the first spreadsheet row at the top, or want to show a ranking from top to bottom. On a column chart, the category axis is normally along the bottom; reversing its categories changes their left-to-right order instead.
Correct the value-axis position if it moves. When categories are reversed on a horizontal bar chart, Excel may move the numeric value axis to the top. This is a side effect of the axis crossing position, not a change in the values. If you prefer the scale along the bottom, select the category axis again and, in Format Axis > Axis Options, find Horizontal axis crosses and choose At maximum category. The exact display can depend on the chart orientation and Excel build. Check that the category order and number scale are both easy to read after changing this setting.
Swap the categories and series. If the chart has the wrong items in its legend or is grouping the data in the wrong direction, select it and choose Chart Design > Switch Row/Column. Excel will reinterpret the rows as series and the columns as categories, or vice versa. For example, a table with regions in rows and quarters in columns may become a chart with quarters as the legend series and regions as the categories. The stacked chart type remains in place, but the number and meaning of the stacks can change substantially. If the result is not what you intended, choose Switch Row/Column again to return to the prior layout.
Change the order of the stacked segments. If the category labels and chart orientation are right but the colored parts of each bar are in the wrong sequence, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, use the Legend Entries (Series) list. Select a series and click the up or down arrow to change its position, then repeat for any other series. Click OK and inspect the legend as well as the bars, because Excel’s legend order follows the series order. This is not the same as reversing categories: it changes the order of the segments within each stack.
Review labels, totals, and readability. Confirm that every category appears once, the legend names describe the colors, and the value scale is appropriate. A stacked chart shows both segment values and their cumulative length, so a segment’s position can make comparisons harder. If the exact value of each segment matters, use data labels or a table alongside the chart. If you changed to a 100% stacked type by mistake, return to Chart Design > Change Chart Type and select the ordinary Stacked Bar or Stacked Column option.

Common Mistakes

Confusing a bar chart with a column chart: In Excel, Bar means horizontal and Column means vertical. Selecting Stacked Bar will not turn horizontal bars upright. Choose Stacked Column when you want vertical stacks.

Using Switch Row/Column to reverse the order: Switch Row/Column changes which data groups form categories and which form series. It is not a simple top-to-bottom or left-to-right reversal. Use Categories in reverse order for category placement, or Select Data to reorder colored series.

Choosing 100% Stacked unintentionally: This chart type scales every category to a full 100 percent. It shows proportions, not the original totals. If the overall size of each category matters, use the standard stacked type.

Editing the wrong axis: A horizontal bar chart has category labels on the vertical axis and values on the horizontal axis. To change category sequence, format the axis with the category names. Formatting the numeric axis changes its scale rather than the order of the bars.

Expecting the chart and source data to rearrange together: Chart axis and series settings change the display, not the order of the worksheet rows. The chart can therefore look reversed while the source table remains unchanged.

Tips

Make a small sketch or note of the desired result before editing: horizontal or vertical stacks, category order, and segment order. That simple distinction makes it easier to choose the right control and to undo only the change you do not want.

Use descriptive headers in the source table. Excel uses these headers for series names and often uses the first column or row for category labels. Blank headers or merged cells can make the legend confusing, especially after switching rows and columns. A tidy rectangular data range with one heading row and one label column is easiest to chart.

For a ranking, sort the worksheet data into the order you want first, then decide whether the axis needs reversing. Excel’s axis reversal changes the visible order without sorting the source rows. Keeping the source order intentional makes later updates easier to understand.

After changing orientation, check the chart title, data labels, and legend placement. Vertical columns can become crowded when there are many categories; horizontal bars are often easier to read when labels are long. Conversely, columns may make time periods or a small set of categories easier to compare.

If you want a reversible experiment, use Ctrl+Z on Windows immediately after a chart change. On Mac, use Command+Z. Undo is most reliable before you make many other edits. You can also select the chart and revisit Change Chart Type or Select Data to adjust the current setup.

Troubleshooting

The chart did not change after selecting a chart type: Click the chart first, reopen Chart Design > Change Chart Type, and confirm the selected option is Stacked Column rather than Stacked Bar. If the chart is a PivotChart, some layout choices may be governed by its PivotTable fields; change the fields or use the PivotChart Analyze tab as appropriate.

Switch Row/Column is unavailable or has no useful effect: Check that the chart is selected and that it is a chart type that supports switching. Also inspect the source range in Chart Design > Select Data. If Excel has included blank rows, extra headings, or the wrong columns, correct the chart data range there. Some charts based on PivotTables cannot be rearranged with the standard Switch Row/Column command; adjust the PivotTable or PivotChart fields instead.

The categories are in the opposite order from what you expected: Reopen Format Axis and check whether Categories in reverse order is selected. Remember that the first data row may appear at the bottom after reversal. If you want the first data row at the top, toggle the setting and inspect the chart rather than relying on the source table’s order alone.

The scale moved to the top or labels overlap: Reversing categories can affect where the value axis crosses. Use the Horizontal axis crosses setting described above if you want to relocate the scale. For crowded labels, widen the chart, reduce the number of categories, shorten category names in the source data, or use a horizontal stacked bar chart rather than a column chart.

The chart looks blank or has unexpected stacks: Verify that the selected data range contains numeric values and that each series has a heading. Text-formatted numbers, empty cells, or an accidentally included totals row can produce confusing results. Correct the source range or cell values, then return to the chart and review its series.

In Excel for Mac, the chart commands are also on the Chart Design tab, though the exact tab arrangement and Format Axis pane can vary slightly by build. In Excel for the web, many basic chart edits are available, but some axis and series controls may be more limited. If a setting is missing, open the workbook in the desktop Excel app.

Frequently Asked Questions

How do I flip a stacked bar chart from horizontal to vertical?
Select the chart, choose Chart Design > Change Chart Type, select Column, then choose Stacked Column and click OK. Excel calls vertical charts columns rather than bars.

How do I put the first category at the top?
Right-click the category axis, choose Format Axis, open Axis Options, and select Categories in reverse order. If this moves the value scale, adjust Horizontal axis crosses.

Does Switch Row/Column reverse the order of the bars?
No. It swaps which rows or columns are treated as categories and series. To reverse category order, format the category axis; to change colored segment order, use Chart Design > Select Data.

Can I flip only the colored segments in each stack?
Yes. Open Chart Design > Select Data, select a series under Legend Entries (Series), and use the up or down arrow. The legend order changes with the series order.

Will flipping the chart change my worksheet data?
No. Changing chart type, axis order, or series order changes how Excel displays the chart. Sorting or editing the worksheet data is a separate action.

Why did my totals change after flipping the chart?
You may have selected a 100% Stacked chart type, which converts each category to proportions of a whole. Choose ordinary Stacked Bar or Stacked Column to display the original cumulative values.

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.