How to Flip a Graph in Excel

Your Excel chart looks almost perfect, but something is off - the data is presented backward. Maybe your dates are running from newest to oldest, or your top-performing category is stuck at the bottom of the graph. This common frustration can make an otherwise insightful chart confusing. This guide will walk you through how to flip, reverse, or switch the axes and data in your Excel graphs so they tell the right story.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Does "Flipping a Graph" Mean?

First, let's clarify what "flipping a graph" can mean, as it covers a few different scenarios. You might want to:

• Reverse the category order: Change the order of items on your X or Y axis (e.g., show January-December instead of December-January).
• Reverse the value order: Make the value axis run from high to low instead of the default low to high.
• Swap the X and Y axes: Completely trade what's on the horizontal axis with what's on the vertical axis.

We'll cover how to handle each of these situations step by step.

Method 1: Reverse the Order of Categories on an Axis

This is the most common reason people search for how to flip a graph. You have a table with data in a logical order (like January, February, March), but when you create a chart, Excel displays it in reverse (March, February, January). This happens most often with bar charts, where categories are on the vertical (Y) axis.

Here’s how to fix it.

Let's say you have a simple bar chart showing website blog views per month:

As you can see, March is at the top and January is at the bottom, which is counterintuitive. To flip this:

1. Select the Axis to Change: Right-click on the category axis labels you want to reverse (in this case, “March,” “February,” “January”).
2. Open the Format Axis Pane: From the context menu that appears, select Format Axis.... This will open a "Format Axis" panel on the right side of your screen.
3. Check the Reverse Order Box: In the Format Axis panel, under Axis Options (it usually looks like a little column chart icon), find the checkbox labeled Categories in reverse order.
4. Check the Box: Click the checkbox. Your chart's categories will instantly flip.

Now, your chart will display the months in the correct chronological order, with January at the top:

Graphed

Still Building Reports Manually?

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

Watch the Demo

What About Column or Line Charts?

For charts where the categories are on the horizontal (X) axis - like column charts or line charts - the process is identical. Right-click the horizontal axis labels, open Format Axis..., and check the Categories in reverse order box to flip their position from left-to-right to right-to-left.

A Quick Note on the Value Axis Position

When you reverse the vertical category axis (on a bar chart), you'll notice the horizontal value axis jumps from the bottom to the top of the chart. If you'd prefer it to stay at the bottom, Excel has a setting for that.

In the same Format Axis pane for the vertical axis, look for a section called Horizontal axis crosses. All you need to do is select the At maximum category option. This tells Excel to keep the horizontal value axis at the bottom, even after your categories have been reversed.

Method 2: Reverse the Value Axis Order

Sometimes you need to flip the value axis itself. For example, you might be plotting rankings, where a lower number (like 1st place) is actually better than a higher number (like 10th place). In such cases, you might want the axis to run from high to low instead of low to high.

Let's use a similar chart, but this time it's a column chart:

1. Select the Value Axis: Right-click on the value axis (the one with the numbers). In our example, it's the vertical (Y) axis.
2. Open Format Axis Pane: Just like before, choose Format Axis....
3. Find the Reverse Order Box: Inside the Axis Options, you'll see a checkbox called Values in reverse order.
4. Check the Box: Click the box, and your value axis will immediately flip. The lowest value will now be at the top and the highest value at the bottom.

This trick is excellent for creating a "funnel" effect or visualizing data where smaller is better, such as page load times or error rates.

Heads Up: Just like with the category flip, changing the value axis order will move the category axis's location (from the bottom to the top). In the same "Format Axis" pane for the value axis, look under Vertical axis crosses and select At maximum value to force the category axis back to its original position.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Swap the X and Y Axes Completely

What if you don't just want to reverse an axis - you want to completely swap the data presented on the X and Y axes? This often happens when you realize your message would be clearer with a horizontal bar chart instead of a vertical column chart, or vice versa.

Excel has a one-click button for this, typically called "Switch Row/Column." This command swaps the data in your legend with the data on your category axis.

Step by Step: Using "Switch Row/Column"

Imagine a data table comparing Paid Search traffic vs. Organic Search traffic over three months.

If you create a column chart, Excel might group the data by month (Jan, Feb, Mar) on the X-axis and have the channels (Paid Search, Organic Search) as different colored columns (the series).

But what if you wanted to see the channel performance over time? You'd want Paid Search and Organic Search on the X-axis and group the months as the series.

1. Select Your Chart: Click anywhere on your chart to activate the Chart Design tab in the Excel ribbon.
2. Click "Switch Row/Column": In the Data group of the Chart Design tab, you'll find a button labeled Switch Row/Column. Click it.

That's it! Excel will immediately re-plot your data, swapping the axes and legend information.

You can also access this function by right-clicking the chart, choosing Select Data..., and then clicking the Switch Row/Column button in the dialog box that appears. This method gives you a bit more visual control over the source data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Advanced Tip: Creating a "Sort Order" Helper Column

On rare occasions, Excel's formatting options might not work, especially with complex data sets or specific chart types where the "Categories in reverse order" option is grayed out. In these situations, you can force the order by reorganizing your source data using a helper column.

1. Insert a New Column: Add a new column to the left of your data table. Let's call it "Sort Order."
2. Create a Numerical Order: In this column, type numbers in the order you want your data to appear in the chart. For example, if you want "January" to appear first, put a 1 next to it. If you want "February" second, put a 2 next to it, and so on. To create a reverse order for a list of 10 items, number them 10 down to 1.
3. Sort Your Data: Select your entire data table (including the new "Sort Order" column and your headers), go to the Data tab, and click Sort. In the Sort dialog box, choose to sort by your "Sort Order" column from smallest to largest (or largest to smallest, depending on your desired outcome).
4. Re-create or Update Your Chart: Now that your source data is physically in the order you want, your chart will reflect this new arrangement automatically. If it doesn't, you may need to recreate the chart or adjust its data source range.

While this method is more manual, it gives you complete control over the presentation of your data in any situation.

Final Thoughts

Wrestling with chart formatting in Excel is a common but fixable headache. Whether you need to reverse the order of categories, invert the value axis, or completely swap your rows and columns, the solution is usually just a few clicks away in the Format Axis pane or the Chart Design tab.

For me and my team, all this time spent downloading CSVs and manually tweaking reports in spreadsheets was exactly what led us to build a better way. At Graphed, we designed an experience where you can skip the manual formatting altogether. You just connect your data sources directly - like Google Analytics, Shopify, or Facebook Ads - and then describe the dashboard you want in plain English. The platform automatically generates live, interactive charts, giving you back hours to focus on strategy instead of getting stuck on axis positioning in a spreadsheet.