Microsoft Excel is possibly the best spreadsheet application ever designed for the Windows operating system.. Excel is incredibly feature-rich and just one of the many features that Excel has to offer users is the ability to create scatter charts.. A scatter plot, also known as a scatter plot or scatter chart, is a mathematical diagram that can be used to show the values of two variables using Cartesian coordinates on a graph. Scatter charts are incredibly useful tools, especially for any user who needs to display the results of two different values of two different variables in the same place.
Creating a scatter chart in Excel is pretty straightforward: all you need to do is create a column with the X axis coordinates of the chart and a column with the Y axis coordinates of the chart, feed the raw data to Excel and the wizard . absolute that the app is, will process the data, create a scatter plot and plot the coordinates you gave to the scatter plot. Like all graphics, a scatter plot has an X axis and a Y axis. Sometimes, Excel users, for several reasons, need to swap the axes of a scatter plot with each other, which means they want to change the X-axis values so they are plotted on the Y-axis and the values that are currently on the Y-axis are plotted on the X-axis.
Although it may seem confusing and a bit complicated, it is not: changing the X axis of a scatter chart with its Y axis and vice versa in an Excel spreadsheet is quite easy. The following are the two different methods that you can use to change the axes of a scatter chart in Excel:
Method 1: use the Change row option / column
Microsoft Excel has a row change / column that has a few different uses, one of them is to change the axes or tables and graphs like the average scatter plot. Although the success rate of this method with scatter plots is not that high, still a method worth trying. To try to change the axes of a scatter plot with this method, should:
-
Click anywhere on the scatter plot you see to switch axes and select it.
-
You should now see three new tabs in Excel: Design, Design and Format. Go to the Design tab.
-
In the Data section, locate and click the Change Row button / Excel column to change axes of selected chart.
Method 2: swap the values of each axis with each other
If the Change row option / excel column not working for you, don't fear, It's not the end of the world (at least not yet). You can still change the axes of the target scatterplot by manually swapping the X-axis coordinates of the graph for the Y-axis coordinates of the graph and changing the Y-axis coordinates of the graph for the X-axis coordinates of the graph. Manually swapping the coordinates of each of the axes of the chart with each other is what will cause Excel to change the axes of the scatter plot. If you want to change the axes of a scatter chart in Excel using this method, simply:
-
Right click on the X axis from the scatter plot or on its Y axis, it doesn't really matter which.
-
Click Select data … in the resulting context menu.
-
Click on Edit in the Select Data Source window that opens.
-
Replace whatever is in the X series values: with whatever is in the Y series values: and replace whatever is in the Y series values field: with whatever is in the X Series Values field:
-
Click ok.
-
Click OK once more in the Select Data Source window.
As soon as I click OK, the axes of the selected scatter chart will be reversed and Excel will redraw the scatter chart to reflect the change.
