How to Switch X and Y Axes in a Scatter Chart
As already discussed, a scatter chart shows the independent variable on the horizontal axis and the dependent variable on the vertical axis. To switch the X and Y axes in a scatter chart, Excel provides a straightforward method that doesn’t even require recognizing your data in the worksheet. You can swap X and Y data series directly within the chart. Follow the below steps to swap X and Y axes:
Step 1: Click on the Scatter Chart to select it. Excel will display small handles around the chart area
Step 2: In the “Chart Design” tab that appears on the Excel Ribbon, locate the “Switch Row/Column button”.
Step 3: Click the “Switch Row/Column” button. Excel will instantly swap the X and Y data series in the Chart.
Step 4: The X-axis will now display the values that were originally on the Y-axis, and vice versa.
How to Create a Scatter Plot In Excel?
A scatter plot is a mathematical diagram made using the Cartesian coordinates which are used to display typically 2D-data sets. These are also known as scatterplots, scatter graphs, scatter charts, scattergrams, or scatter diagrams.
In this article, we will look into how we can create scatter plots in Excel. To do so follow the below steps: