How to Flip Axis in Excel Chart

Building a chart in Excel is often a drag-and-drop affair, but sometimes Excel gets your data exactly backward. Suddenly, the months you wanted on the bottom are listed on the side, or your bar chart is showing sales from lowest to highest when you need the reverse. This quick guide will walk you through exactly how to flip or switch the axes in any Excel chart to get your data telling the right story.

Understanding the Two Types of "Axis Flipping"

First, it's important to clarify what you mean by "flipping" an axis, as there are two common but very different actions people want to take:

1. Switching the X and Y axes: This means you want what's currently on the horizontal (X) axis to be on the vertical (Y) axis, and vice versa. This typically happens when Excel misinterprets your data, plotting your data series as categories and your categories as data series. Visually, it would be a bit like turning your chart 90 degrees conceptually. We do this with the Switch Row/Column feature.
2. Reversing the order of an axis: This means you want to invert the order of the items on a single axis. For example, making your vertical axis count down from 100 to 0 instead of up from 0 to 100, or showing categories on the horizontal axis from right-to-left instead of left-to-right. We do this using the Format Axis options.

Knowing which action you need is the first step. Let's cover how to perform each one in detail.

Method 1: How to Switch the Horizontal and Vertical Axes

This is the most common fix you'll need. Let's say you have a simple dataset of monthly subscription revenue.

You highlight your data and insert a column chart, but Excel produces something weird, where the months are on the vertical axis and the revenue values are on the horizontal. This makes the chart confusing and hard to read. You want to swap them.

There are two quick ways to do this.

Using the "Switch Row/Column" Button (The Fast Way)

This is a one-click fix designed specifically for this problem.

• Step 1: Select your chart. Click anywhere inside your chart. This will bring up the contextual chart tabs in the Excel ribbon at the top of the screen, typically labeled "Chart Design" and "Format."
• Step 2: Go to the Chart Design tab. Make sure you have the "Chart Design" tab selected.
• Step 3: Click "Switch Row/Column". In the "Data" group of the Chart Design tab, you'll find a button called "Switch Row/Column." Click it.

Instantly, Excel will swap your axes. Your months (the categories) will now be plotted correctly on the horizontal axis, and your revenue (the data series) will be represented by the vertical bars. The resulting chart is now intuitive and easy to read.

Using the "Select Data" Dialog Box (More Control)

Sometimes you need a bit more control or want to understand what's happening behind the scenes. The "Select Data Source" window provides another way to switch axes and manage your data series individually.

• Step 1: Right-click the chart. Position your cursor over an empty area of your chart and right-click to open the context menu.
• Step 2: Choose "Select Data." From the menu, click on "Select Data." This will open the "Select Data Source" dialog box.
• Step 3: Click the "Switch Row/Column" button. Inside this dialog box, you'll see two main panels: "Legend Entries (Series)" on the left and "Horizontal (Category) Axis Labels" on the right. In the middle, there's a button, just like in the ribbon, labeled "Switch Row/Column."
• Step 4: Click the button and check the result. Click it to instantly swap the items listed in the "Legend Entries" and "Horizontal Axis Labels" panels. You'll see the change reflected in the background chart preview.
• Step 5: Click "OK." Once you're happy with the alignment, click "OK" to apply the changes.

This method accomplishes the same thing as the ribbon button but is useful if you also want to add, edit, or remove specific data series while you're in there. For most people, simply clicking the button in the "Chart Design" tab is the fastest solution.

Method 2: How to Reverse the Order of Values or Categories on an Axis

Maybe your axes are in the right place, but they're just backward. For instance, your bar chart shows the top-performing item at the bottom, or your timeline of years reads 2024, 2023, 2022 from left to right. This is where you need to reverse the plot order of a single axis.

Flipping the Vertical (Value) Axis

Let's say you have a bar chart showing website traffic from different sources, and you want to display the highest traffic source at the top. By default, Excel might plot it at the bottom. Here's how to flip the vertical axis to fix that.

• Step 1: Select the vertical axis. Click directly on the vertical (Y) axis labels (the numbers or categories on the left side of the chart). A box should appear around them, indicating they are selected.
• Step 2: Open the "Format Axis" pane. Right-click the selected axis and choose "Format Axis" from the menu. A formatting pane will appear on the right side of your screen.
• Step 3: Check "Values in reverse order." In the "Format Axis" pane, make sure you're in the "Axis Options" tab (it looks like a small bar chart). Find the "Axis Options" section, and you'll see a checkbox labeled "Values in reverse order." Check this box.
• Step 4 (Important): Adjust the horizontal axis position. When you reverse the vertical axis, a common side effect is that Excel moves the horizontal axis to the top of the chart. To fix this, stay in the "Format Axis" pane and look for the section called "Horizontal axis crosses." Select the radio button for "At maximum value." This tells Excel to place the X-axis back at the bottom, where it looks most natural.

Flipping the Horizontal (Category) Axis

The process for reversing the order of the horizontal axis is nearly identical. You might use this if you want to show a timeline in reverse chronological order or just change the display of your categories.

• Step 1: Select the horizontal axis. Click on the horizontal (X) axis labels at the bottom of the chart.
• Step 2: Open the "Format Axis" pane. Right-click the selected axis and choose "Format Axis."
• Step 3: Check "Categories in reverse order." In the "Format Axis" pane, under "Axis Options," you'll find a very similar checkbox labeled "Categories in reverse order." Click it.

The categories on your horizontal axis will now be plotted in the opposite direction (from right to left instead of left to right). Since this doesn't move another axis, no further adjustments are usually needed.

Best Practices and Quick Tips

• It's All About Your Source Data Layout: Often, axis problems can be prevented by how you structure your data. Excel typically assumes that if you have more columns than rows, the columns are your categories. If you have more rows than columns, it assumes the rows are your categories. Keeping this in mind can save you a click later.
• Use the Right Chart Type: A column chart is great for comparing a few categories over time, but if you have many categories with long names (like product names or marketing channels), a bar chart (with categories on the vertical axis) is often easier to read. Switching to a bar chart might solve your readability problem better than just flipping axes.
• Labels Matter: No matter which way your axes face, make sure they are clearly labeled. Add axis titles by clicking the "+" icon next to your chart and checking "Axis Titles." A chart without properly labeled axes is just a picture, not a source of information.

Final Thoughts

Figuring out how to flip an axis in Excel is simple once you know the difference between switching rows and columns versus reversing an existing axis's order. Using "Switch Row/Column" handles misused data, while the "Format Axis" pane gives you direct control over the display order, putting you in charge of how your story is visualized.

Spending time on manual chart adjustments and corrections in Excel is a familiar process for many teams. At Graphed, we built a tool to eliminate that busy work. Instead of wrestling with data sets and formatting options manually, we let you connect data from sources like Salesforce, Google Analytics, or HubSpot and create reports simply by describing what you want to see. Your dashboards are built in seconds and stay updated with live data automatically, giving you back time to focus on insights and not on chart configurations.