Quick Links:

As an Amazon Associate we may earn from qualifying purchases made via links on our website.

ComputingHow to switch X and Y-axis in Microsoft Excel

How to switch X and Y-axis in Microsoft Excel

These days, almost everyone uses Microsoft Office on a daily basis. Although most people claim to be proficient in Office, this is far from the case. Excel, in particular, is not even remotely easy to use, especially if you are not tech-savvy. When you create graphs based on Excel tables, the program automatically calculates values and builds a graph based on these calculations, but there is a possibility that the automatically created graph will be uncomfortable or unattractive. To fix it, you just need to swap the axes: the X-axis should be vertical and the Y-axis should be horizontal.

Whether you’re a student, a business owner, or you love charts and graphs, you need to know how to use Excel. One of the most frequently asked questions about Excel is how to change the X-axis and the Y-axis. So, here is how to switch the X and Y-axis in Microsoft Excel.

What is a chart axis

Charts in Excel are not that complicated if you know what to expect. There is an X-axis and a Y-axis. The first one is horizontal and the second one is vertical. When you change the horizontal X-axis, you change the categories within it. You can also change its scale for easier viewing.

The horizontal axis shows either the date or text showing different intervals of time. This axis is not numerical like the vertical axis. The vertical axis shows the value of the corresponding categories. You can use many categories, but be mindful of the size of the chart so that it will fit on the Excel page. The best number of data sets for a visual Excel chart is four to six. If you have more data to display, perhaps divide it into multiple charts, which is not difficult to do.

How to switch X and Y-axis in Microsoft Excel

If you want to switch the X and Y-axis in Microsoft Excel, you have to follow these steps:

  • First of all, right-click on one of the axes and select “Select Data”. This way you can also change the data source for the chart.
  • In the “Select Data Source” dialog box, you can see the vertical values, which are the X-axis. Also on the right are the horizontal values, which are the Y-axis. To switch axes, you must click on the “Edit” button on the left.
  • The popup shows that the X series values are in the range “=Sheet1!$B$2:$B$10” and the Y series values are in the range “=Sheet1!$C$2:$C$10”.
  • To change the values, you need to swap the two ranges so that the range for the X series becomes the range for the Y series and vice versa. So, in the X series values, enter “=Sheet1!$C$2:$C$10” and in the Y series values, enter “=Sheet1!$B$2:$B$10”.
  • Then, confirm changes, you will be redirected back to the “Select Data Source” window, and click “OK”.

Once you have completed these steps, the X and T-axis will be switched.

Discuss

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Related articles

More for you