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 .
In club to create a chart, you need to follow the below steps :
- Select a range of values that you want to present on a chart (in this example B1:C10)
- Go to the Insert tab
- Select Insert Scatter chart icon
- Choose the Scatter chart
As a result, you get the disperse chart as shown below ( where I have highlighted the axis using the arrow ) .
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 :
- 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.
- 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.
- 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”.
- 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”.
- 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 .
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: