How to Flip Axis in Excel (4 Easy Methods)

When we insert a chart in Excel, Excel automatically creates a horizontal axis and a vertical axis of the chart using the dataset. However, in many cases, you may need to flip the axis of the chart created automatically by Excel. If you want to flip axis in Excel, you have come to the right place. Here, we will walk you through 4 easy methods to do the task effortlessly.

Download Practice Workbook

You can download the Excel file and practice while you are reading this article.


4 Methods to Flip Axis in Excel

The following dataset has the Product and Sales columns. Using this dataset, we will demonstrate to you 4 methods to flip axis in Excel. Here, we used Excel 365. You can use any available Excel version.

How to Flip Axis in Excel


1. Using Format Axis Feature to Flip Axis in Excel

In this method, first, we will insert a Bar chart, and after that, we will use the Format Axis feature to flip the axis in Excel.

Let’s go through the following steps to do the task.

Step-1: Inserting Bar Chart

In this step, we will insert a Bar chart.

  • First of all, we will select the entire dataset >> go to the Insert tab.
  • Afterward, from Insert Column or Bar Chart >> select 2D Clustered Bar chart.

As a result, you can see the Bar chart.

How to Flip Axis in Excel

  • Moreover, we edited the Chart Title to Product Sales.

Hence, you can see the Bar chart with Chart Title.

Here, you can easily notice in the Bar chart, that the horizontal axis has the Sales value and the Vertical axis has the Product.

Furthermore, we will flip the axis.

Step-2: Flipping Bar Chart Axis

In this step, we will use the Format Axis feature to flip the axis of the Bar chart.

  • In the beginning, we will select the horizontal axis >> right-click on it.
  • Then, from the Context Menu, select Format Axis.

How to Flip Axis in Excel

Therefore, you will see a Format Axis dialog box appear at the right end of the worksheet.

  • At this point, from the Axis Options >> mark Values in reverse order.

Therefore, you can see the axis of the chart has flipped.

How to Flip Axis in Excel

Read More: How to Flip Bar Chart in Excel (2 Easy Ways)


2. Use of Select Data Option to Flip Axis in Excel

In this method, first, we will insert a Scatter chart using the following dataset, and after that, we will use the Select Data option to flip axis in Excel.

Let’s go through the following steps to do the task.

Step-1: Inserting Scatter Chart

  • First, select the entire Sales and Quantity columns by selecting cells C4:D9 >> go to the Insert tab.
  • Afterward, from Insert Scatter (X,Y) or Bubble Chart >> select Scatter chart.

Therefore, you can see the Scatter chart.

How to Flip Axis in Excel

  • Moreover, we edited the Chart Title to Sales and Quantity.

Hence, you can see the Scatter chart with Chart Title.

Here, you can easily notice that Sales takes the horizontal axis and Quantity takes the vertical axis.

Next, we will flip the axis.

Step-2: Flipping Scatter Chart Axis

In this step, using the Select Data option, we will flip the axis of the Scatter chart.

  • First of all, we will select the Scatter points by clicking on one of the points.
  • Then, we will right-click on it.
  • After that, we will select the Select Data option from the Context Menu.

How to Flip Axis in Excel

At this point, a Select Data Source dialog box will appear.

  • Furthermore, click on Edit.

Moreover, an Edit Series dialog box will appear.

Here, you can notice that Series X values have cells C5:C9.

Along with that, Series Y values have cells D5:D9.

How to Flip Axis in Excel

  • Furthermore, we will select cells C5:C9 in the Series Y values box.
  • Along with that, we will select cells D5:D9 in the Series X values box.

This will flip the axis of the chart.

  • In addition, click OK.

  • Moreover, click OK in the Select Data Source dialog box.

How to Flip Axis in Excel

Then, you can easily notice that Sales now takes the vertical axis and Quantity takes the horizontal axis.

Therefore, you can flip the chart in Excel.

Read More: How to Flip Data from Horizontal to Vertical in Excel (6 Methods)


Similar Readings


3. Sorting Main Dataset to Flip Axis

In this method, we will sort our dataset to flip axis in Excel.

Let’s go through the following steps to do the task.

Step-1: Inserting Column Chart

In this step, we will insert a Column chart.

  • First of all, we will select the entire dataset >> go to the Insert tab.
  • Afterward, from Insert Column or Bar Chart >> select 2D Clustered Column chart.

How to Flip Axis in Excel

As a result, you can see the Column chart.

  • Moreover, we edited the Chart Title to Product Sales.

Here, you can easily notice in the Column chart, that the horizontal axis has the Sales value and the Vertical axis has the Product.

Furthermore, you can notice that the starting column is for the product Laptop which has the highest Sales. And the last column is for the product Printer.

Therefore, the chart axis is in descending order.

Next, we will flip the chart in a way so that the Printer becomes the first Column of the chart. Hence, we want to see the chart in ascending order.

How to Flip Axis in Excel

Step-2: Flipping Axis of Column Chart

In this step, we will flip the axis of the Column chart in ascending order.

  • In the beginning, we will select the entire dataset >> go to the Home tab.
  • Next, from the Sort & Filter group >> select Sort Z to A.

As a result, you can see the dataset has been sorted from small Sales to large Sales.

Moreover, as soon as we sort the dataset, the Column chart gets updated.

Here, you can see the columns of the chart are in ascending order.

How to Flip Axis in Excel

Read More: How to Flip Excel Sheet from Left to Right (4 Easy Ways)


4. Using Change Series Chart Type Feature

In this method, first, we will insert a Bar chart, and after that, we will change the chart type to a Column chart using the Change Series Chart Type feature. Therefore, we will flip the axis in Excel.

Let’s go through the following steps to do the task.

  • First of all, we followed Step-1 of Method-1 to inset a Bar chart. Along with that, we edited the Chart Title.

As a result, you can see the Bar chart.

Here, you can easily notice in the Bar chart, that the horizontal axis has the Sales value and the Vertical axis has the Product.

Furthermore, we will flip the axis.

How to Flip Axis in Excel

  • After that, we will select the Bars by clicking on one of the bars.
  • Then, we will right-click on it.
  • Afterward, we will select Change Series Chart Type option from the Context Menu.

At this point, a Change Chart Type dialog box will appear.

  • Then, from All Charts >> select Column >> select Clustered Column chart.
  • Next, click OK.

How to Flip Axis in Excel

As a result, you can see the Column chart.

In the Column chart, the vertical axis has Sales and the horizontal axis has Product.

Hence, we flip the chart axis in Excel.

Read More: How to Flip Data in Excel Chart (5 Easy Methods)


Practice Section

You can download the above Excel file to practice the explained methods.

How to Flip Axis in Excel


Conclusion

Here, we tried to show you 4 methods to flip axis in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website Exceldemy to explore more.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo