How to Switch Axis in Excel (Switch X and Y Axis) – Spreadsheet Planet

sometimes, when you create a graph in Excel, you may want to switch the bloc in the chart ( i.e, interchange the x and the Y-axis )
It ’ south very comfortable and in this short tutorial, I will show you how you can switch axis in Excel charts with a few clicks .
indeed let ’ s draw started !

Understanding Chart Axis

If you create a chart ( for example column or bar ), you will get the X and Y-axis.

The x-axis is the horizontal axis, and the Y-axis is the vertical axis .
Axis has values ( or labels ) that are populated from the chart data .
Let ’ s now see how to create a scatter chart, which will further make it clear what an axis is in an Excel chart .
For creating a chart, I will be using the below data specify, which contains products in column A, Sales value in column B, and Quantity value in column C .
Dataset to create a scatter chart In club to create a chart, you need to follow the below steps :

  1. Select a range of values that you want to present on a chart (in this example B1:C10)
  2. Go to the Insert tab
  3. Select Insert Scatter chart icon
  4. Choose the Scatter chart

As a result, you get the disperse chart as shown below ( where I have highlighted the axis using the arrow ) .
Scatter chart with X andY axis This chart has the X-axis ( horizontal ) with values from the Sales column and Y-axis ( vertical ) with values from the Quantity column .
When you create a graph in Excel, it automatically decides the crop that needs to be shown in the axis .
now that ’ s all dear ! But what if I want a chart where Sales is in Y-Axis and Quantity in X-axis .
thankfully, Excel allows you to well switch the X and Y axis with a few clicks.

Let ’ s see how to do this !

Switch X and Y Axis in Excel

now, if you want to display Sales values on the Y-axis and Quantity values on X-axis, you need to switch the bloc in the chart .
Below are the steps to do this :

  1. You need to right-click on one of the axes and choose Select Data. This way you can also change the data source for the chart.

Right-click on the axis and click on Select Data

  1. In the ‘Select Data Source’ dialog box, you can see vertical values (Series), which is X axis (Quantity). Also, on the right side there are horizontal values (Category), which is Y axis (Sales). You have to click on the Edit on the left side in order to switch axes.

Click on the Edit button

  1. In the pop up window, you can see that Series X values are range “=Sheet1!$B$2:$B$10”, and the Series Y values are range “=Sheet1!$C$2:$C$10”.

Edit Series dialog box

  1. In order to switch values, you have to swap these two ranges, so that the range for series X becomes a range for series Y and vice versa. So, in Series X values, enter “=Sheet1!$C$2:$C$10”, and in Series Y values, enter “=Sheet1!$B$2:$B$10”.

Swap the X-axis and Y-axis range

  1. After you confirm changes, you will be redirected back to the Select Data Source window, and click OK.

ultimately, your chart has a switched axis. As you can see, Sales values are now on the Y-axis, and Quantity values are on the x-axis .
Chart where axis have been switched

Rearrange the Data to Specify the Axis

The above method works big when you have already created the graph and you want to swap the axis .
But if you haven ’ triiodothyronine created the graph already, one way could be to rearrange the data so that excel picks up the data and plots it on the X and Y axis as per your needs .
excel by default sets the foremost column of the data beginning on the x-axis, and the moment column on the Y-axis .
In this case, you can merely move Quantity in column B, and Sales in column C .
Switching the axis choice in a chart gives you more tractability for adjusting the graph axis. besides, this way you don ’ t need to change any data in your tabloid .
So these are two simpleton and easy ways to switch the axis in Excel charts.

While I have shown an exemplar of a disperse graph in this tutorial, you can use the same steps to switch axis in case of any graph in Excel .
I hope you found this Excel tutorial utilitarian !
Other Excel tutorials you may also like:

generator :
Category : Tech

About admin

I am the owner of the website, my purpose is to bring all the most useful information to users.

Check Also


Manage participants in a zoom meeting webinar

Call the people who attend the meet as follows Alternate host host Who scheduled the …

Leave a Reply

Your email address will not be published.