How to Reverse Data in Excel Chart

Trying to make your Excel chart show data in the right order can be one of those surprisingly frustrating tasks. You set up your data logically, with January at the top and December at the bottom, but the chart flips it, showing December first. You’re not doing anything wrong, Excel just has its own way of plotting information. This guide will walk you through exactly how to reverse the data order in your charts, getting them lined up just the way you want.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Excel Plots Your Data in Reverse Order

Before we jump into the fix, it helps to understand why this happens. Imagine your spreadsheet. You read it from top to bottom. Excel does this too. Now picture a standard bar or line chart. The vertical axis (the Y-axis) starts with its lowest value at the bottom and goes up.

When Excel creates a chart, it takes the first category (the top row in your data) and plots it at the bottom-most position on the vertical axis. It then takes the second row and plots it in the next position up, and so on. So, if your data is arranged chronologically from January to December, Excel places January at the bottom of the chart and works its way up to December at the top. It's logical from a plotting perspective, but it’s often the opposite of how we want to read it.

There are two main things you might want to reverse:

• The order of categories on an axis: E.g., making a bar chart show months January-December from top to bottom.
• The order of data series in the legend: E.g., in a stacked bar chart, changing which data series appears at the bottom versus the top.

Let’s walk through how to control both.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Reverse the Order of Categories on the Vertical (Y) Axis

This is the most common fix people search for. You have a list of products, months, or salespeople, and you want them to display in your chart in the same top-to-bottom order as your source data. For this example, let's use a simple bar chart showing sales per month for the first quarter.

Your source data looks like this:

Month | Sales

• Jan | $10,000
• Feb | $15,000
• Mar | $12,000

When you create a bar chart from this, Excel will likely display "Mar" at the top and "Jan" at the bottom. Here is how to fix it in a few clicks.

Step-by-Step Instructions

1. Right-click the Vertical Axis: Click on the axis labels you want to reverse (in our case, "Mar", "Feb", "Jan"). A context menu will appear.
2. Select "Format Axis": This will open the Format Axis pane, usually on the right side of your screen. This is your control panel for everything related to that axis.
3. Check the Right Box: In the Format Axis pane, make sure you are on the "Axis Options" tab (it looks like a small bar chart icon). Look for a checkbox labeled Categories in reverse order.
4. Tick the Box: Simply click the checkbox. You’ll see your chart update instantly, and the vertical axis categories will flip. "Jan" will now be at the top and "Mar" at the bottom, matching your data table's layout.

That’s it! Your categories are now in the correct order.

Fixing a Common Side Effect: The Horizontal Axis Jumps to the Top

When you reverse the vertical axis, you might notice something annoying happens: your horizontal axis (the X-axis, showing the sales values in our example) jumps to the top of the chart.

This happens because Excel’s default setting is to place the horizontal axis at the zero point or the first category of the vertical axis. Once you reverse the order, the "start" of the vertical axis is now at the top. Fortunately, this is just as easy to fix.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Move the Horizontal Axis Back to the Bottom

1. Stay in the "Format Axis" Pane: You don't need to leave the control panel you just used. Make sure the vertical axis (Y-axis) is still selected.
2. Find "Horizontal axis crosses": Within the "Axis Options" tab, look for the section titled Horizontal axis crosses.
3. Set it to the Maximum Category: You'll see two radio button options: "Automatic" and "At maximum category." Change the selection from "Automatic" to At maximum category.

As soon as you make this change, the horizontal axis will move back down to the bottom of the chart, right where you expect it to be. The "maximum category" is simply the last item in your list, which is now plotted at the bottom after reversing.

How to Reverse the Order of Data Series (Legend Order)

Sometimes the issue is not the axis but the order in which your data series are plotted. This is common in charts with multiple data series, like stacked columns or charts comparing two different sets of numbers. Reversing the series changes either the stacking order or the left-to-right order of your bars and their corresponding legend entries.

Imagine you have data comparing "Projected Sales" vs. "Actual Sales" for each month:

Month | Projected Sales | Actual Sales

• Jan | $9,000 | $10,000
• Feb | $14,000 | $15,000
• Mar | $13,000 | $12,000

On a stacked column chart, Excel might place "Actual Sales" on the bottom and "Projected Sales" on top. If you wanted to see "Projected" as the base and "Actual" stacked on it, you'd need to reverse the series order.

Step-by-Step Instructions

1. Right-click the Chart: It's best to right-click on the main plot area of your chart, not a specific element like an axis or title.
2. Choose "Select Data": From the menu that pops up, click on Select Data. This will open the Select Data Source dialog box.
3. Identify the Legend Entries (Series): In this window, you'll see a box on the left titled Legend Entries (Series). It lists your data series in their current plot order - in this case, probably "Projected Sales" and then "Actual Sales".
4. Reorder the Series: Click on the series you want to move. For our example, let's say "Actual Sales" is currently listed second and we want it to be first. Click on "Actual Sales," and then use the small up and down arrows located just above the list to change its position. Move it up to the first spot.
5. Click "OK": Once you have the order you want, click the OK button. Your chart will instantly update to reflect the new series order. The legend and the way your bars are grouped or stacked will now be reversed.

Alternative Method: Manually Reverse the Source Data Itself

While the chart formatting tools are usually the best way to go, you can also solve this problem by physically reordering your source data in the spreadsheet. The chart is just a visual reflection of your spreadsheet, so if you reverse the rows in the sheet, the chart order will follow.

This is a more permanent solution and can be useful if the reversed order is also better for the table itself.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Quickly Sort Your Data in Reverse

1. Add a Helper Column: Insert a new column next to your data. Let's call it "Sort Order."
2. Number Your Rows: In this new column, enter a sequence of numbers from 1 to the end of your data. (An easy trick: type 1 in the first row, 2 in the second, then select both cells and drag the small green fill handle down to the last row).
3. Sort the Data: Now, select your entire data set, including the new helper column. Go to the Data tab in Excel's ribbon and click the Sort button.
4. Sort by the Helper Column: In the sort dialog box, set the "Sort by" dropdown to your "Sort Order" column. Then, for the "Order," choose Largest to Smallest. Click OK.

Your spreadsheet data will now be physically reversed, and your chart will update to show this new order. The main advantage here is straightforward control, but the downside is that your source data is rearranged, which you might not want for other purposes.

Final Thoughts

Fixing the plot order in an Excel chart is a staple skill for anyone who regularly builds reports. Using the "Format Axis" pane to reverse categories - and remembering how to move the horizontal axis back down - is the fastest way to get your classic bar and line charts looking right. For more complex charts, the "Select Data" window gives you direct control over how different data series are layered or grouped.

While these Excel tricks are great to have in your back pocket, they highlight how much time we can spend fighting with formatting instead of focusing on what our data says. To sidestep this completely, we built Graphed. You just connect your data sources, tell it what you want in plain English - like "create a bar chart showing Shopify sales by month for this quarter, with January at the top" - and it builds the real-time dashboard for you, formatting included. You can get straight to the insights without the tedious setup.