How to Flip Order of Bar Chart in Excel

Ever create a bar chart in Excel only to find the bars are in the exact opposite order of your data table? It’s a common and incredibly frustrating issue. You’ve neatly organized your data from top to bottom, but Excel insists on displaying it from bottom to top. This article will show you two quick and painless methods to flip the order of your bar chart and get it looking exactly how you want.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Does Excel Reverse the Bar Chart Order Anyway?

Before jumping into the fixes, it helps to understand why Excel behaves this way. It's not a bug, it's a feature based on how charts are drawn. Think of a standard two-axis graph from your school days. The vertical (Y-axis) values always start at the bottom (zero) and increase as you go up.

Excel applies this same bottom-to-top logic to the categories in your bar chart. It takes the first category listed in your data table and plots it at the bottom-most position on the chart - the "starting point" of the vertical axis. The next row in your data becomes the next bar up, and so on. The final row of your data ends up at the very top of the chart.

For example, if you have a table of monthly sales from January to December:

• Your brain reads the table top-to-bottom: January, February, March...
• Excel reads it for the chart bottom-to-top: it places January at the bottom, February above it, and so on, leaving December at the top.

This is logical from a charting perspective but completely counterintuitive for the user. Fortunately, there are a couple of very effective ways to fix it.

Method 1: The Quickest Fix (Using Chart Format Options)

This is the best and fastest method for most situations. It doesn’t require you to change your source data at all. You’re simply telling Excel to change how it displays the chart's axes.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Guide to Reversing the Axis

Let's use our monthly sales example again. We have a table and a bar chart where December is at the top and January is at the bottom — the reverse of what we want.

Step 1: Select and Format the Vertical Axis

First, right-click on the vertical axis of your chart. This is the axis that displays your category labels (e.g., "January," "February," etc.). In the menu that appears, click on Format Axis.

Step 2: Find the "Categories in reverse order" Option

A “Format Axis” panel will open up on the right side of your Excel window. Make sure you’re in the "Axis Options" section, which is usually represented by a small bar chart icon.

In this list of options, you'll see a checkbox labeled "Categories in reverse order." Go ahead and check that box.

Instantly, you'll see the magic happen. The bars on your chart will flip, and your data will now be displayed in the correct top-to-bottom order you intended — January at the top, December at the bottom. Success!

However, you just traded one small problem for another...

The Follow-Up Fix: Moving the Horizontal Axis Back to the Bottom

When you reverse the category order, Excel also moves the horizontal (value) axis to the top of the chart. This can look quite strange and make your chart hard to read. Thankfully, fixing this is just one more click away.

Step 3: Adjust the Horizontal Axis Position

In that same "Format Axis" pane, look for the section called "Horizontal axis crosses." By default, it's set to "Automatic." You just need to change this setting.

Select the option for "At maximum category."

This tells Excel, "Even though the categories are in reverse plotting order, I always want the value axis to stay at the bottom." Your horizontal axis will jump back down to its familiar position, and your chart is now perfectly formatted.

This entire process takes less than 30 seconds once you know where to look. It's reversible, clean, and doesn't interfere with your source data at all.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 2: Reversing the Source Data Itself

Sometimes, you might want to adjust the original data table instead of just the chart. This method is useful when you need the table display to match the chart display for reporting purposes or if a formatting-based fix isn’t working with your specific chart setup. It involves adding a temporary "helper" column to sort your data.

Step-by-Step Guide to Sorting Source Data

Let’s start with our same original data, with January at the top and December at the bottom of the table.

Step 1: Create a Helper "Sort" Column

In an empty column next to your data (e.g., column C if your data is in A and B), give it a header like "Sort Order."

In the first row of that column, type the number 1. In the row below it, type 2. Now, select both of those cells (containing 1 and 2), and drag the small fill handle (the little square in the bottom-right corner) down to the end of your data. Excel will automatically fill the series for you (3, 4, 5, etc.).

Step 2: Sort Your Data in Reverse

Now, select all your data, including the new helper column. Go to the Data tab in Excel's ribbon and click the Sort button. This will open the Sort dialog box.

In the dialog box, set it up like this:

• Sort by: Choose your new helper column ("Sort Order").
• Sort On: Keep it as "Cell Values."
• Order: Change this to "Largest to Smallest."

Click OK. Your table will instantly be re-sorted, with the last item (December) now at the top and the first item (January) at the bottom.

Step 3: Check Your Chart

If your bar chart was already created from this data range, it will update automatically. Because Excel plots from the bottom up, it will take the now-bottom row ("January") and plot it last, meaning it will appear at the top of the chart. Your chart now displays the correct order precisely because your data source is reversed.

You can now delete the "Sort Order" helper column if you no longer need it. Excel will keep the table in its new order.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Which Method Should You Choose?

• Use Method 1 (Format Axis) 99% of the time. It's faster, non-destructive, and built specifically for this purpose. It keeps your data organized logically while giving you control over the visual presentation.
• Use Method 2 (Source Data Sort) only when you have a specific need for your actual data table to be physically reversed.

Bonus: What About Column Charts?

While the reversed order issue is most common with horizontal bar charts, it can also happen with vertical column charts. In that case, the categories are plotted on the horizontal (X-axis) and the values on the vertical (Y-axis).

Excel plots the horizontal categories from left to right, following the order in your data table. But what if you wanted to display them from right to left? The fix is exactly the same!

1. Right-click the horizontal axis (where your category labels are).
2. Select Format Axis.
3. Check the box for "Categories in reverse order."

This will move your first data point to the far-right side of the chart and the last data point to the far-left. You can then use the companion option, "Vertical axis crosses at," to control where the Y-axis line appears.

Final Thoughts

Fixing the display order in an Excel bar chart is simple once you know where the settings are hidden. For a quick visual reversal, the "Format Axis" option is a powerful tool that leaves your source data untouched, while a manual sort offers a more permanent solution when you need both your table and chart aligned.

Wrestling with small but mighty formatting problems like this is a familiar part of building manual reports. At our company, we experienced so much of this friction - exporting CSVs, fighting with chart settings, and spending hours on repetitive formatting - that we decided to build a better way. With our tool, Graphed, you simply connect your data sources and describe the chart you want in plain English. Instead of clicking through menus, you can just ask, "Show me a bar chart of sales by month for Q4 with December on top," and it's built for you instantly, using live data, and formatted correctly from the start.