Excel is a powerful spreadsheet program many people use to track their finances. With the ability to switch between the two major axes, it can be hard to keep track of which column corresponds to which data point in your data set. This article will show how to change the Excel axis to track your finances efficiently. This also can be helpful when you have many data sets and want to quickly find the information you need.
Contents
How to Create a Scatter Chart?
To switch axis in excel, you have to create a chart and then get the X and Y axes. The X axis is horizontal, and the Y axis is vertical. To create a scatter chart, we use the below data sheet.
That datasheet contains information such as the Product list in Column A, Sales range in Column B, and Quantity value in Column C. The steps below can easily create a scatter chart.
Step 1:
Select the range of your value. Here we select B1:C10. And go to the Insert Tab.
Step 2:
In the Charts section, click the scatter chart icon.
Step 3:
Now select your scatter chart.
Step 4:
Now you get the scatter chart below.
This chart shows the seals’ column value on the X axis or horizontal axis and the Quantity column values on the Y axis or vertical axis. Now you can easily switch axis in excel.
Let’s see how we can do it in simple steps.
How to Switch Axis in Excel? 3 steps
If you need to change the order of your data in an Excel spreadsheet, you can do so by switching the axis. This quick and easy process can be done in just a few steps.
1. Select Data Source
First right, click on your axis to select a data source. In this way, you can also change the chart’s data source.
2. Switch Row/Column
After opening the select data source diagram, you can easily optimize the vertical and horizontal values of the X and Y axes. To switch the axis, you have to click the edit option.
3. Elite Series
Here open an Edit Series window. In this window, you can see the Serice name, series X values, and Y values change values. You will need to switch the ranges for series X and Y. In the Series X values,
enter “=Sheet1!$C$2:$C$10”, and in the Series Y values,
enter “=Sheet1!$B$2:$B$10”.
You will be redirected to the Select Data Source window after confirming the changes. Click OK to continue.
The chart’s axis has been switched. As shown, Sales values are now on the Y-axis, and Quantity values are on the X-axis.
