Click on the upward arrow button next to it.Highlight the entire text in Series Y Values and press DEL.Repeat steps 4 to 6, only this time, do it on the Series Y values field. Next, we are going to edit the range for the y-axis.
Doing so will lead you back to the Edit Series form.ħ. Once selected, click on the downward arrow button. Once you see that, highlight the numeric values in your data that you want to move to the x-axis. The blank Edit Series form should appear.Ħ. This button will let you select the range that will serve as the basis for the values on the x-axis. Next, click on the upward arrow button next to the textbox. Highlight the entire text in Series X values and press DEL.ĥ. First, we are going to reset the contents of the x-axis. You should now see the Edit Series form (as shown below).Ĥ. Once the Select Data Source form appears, click on the Edit button under the Legend Entries (Series) section.ģ. From the list of options that appear, click on Select Data.Ģ. Change the X-axis and Y-axis on a Scatter Plot by Editing the Seriesġ. If for any reason, you need to swap the two, you can do the steps listed in the following options. In theory, the x-axis values refer to the independent variables, and the y-axis values refer to the dependent variables. When you create a scatter chart in Excel, the leftmost numeric column in the dataset, by default, becomes the x-axis, while the column that comes after it becomes the y-axis.
#4 DATA SET XY SCATTER PLOT EXCEL HOW TO#
In this tutorial, I will show you how to switch the x-axis and the y-axis in a Scatter Chart. The perpendicular lines on the graph refer to the x and y axes.
#4 DATA SET XY SCATTER PLOT EXCEL PLUS#
But it can be other symbols too, like square, triangle, plus sign, etc. We typically use a dot to represent the point of intersection between two numeric variables. All these can help in analyzing and interpreting our dataset. We use it to identify the patterns within the data and see if there are any unexpected gaps or outlier points. We draft a scatter chart (also known as a scatter graph or plot) to showcase the relationship between two variables. Did you know that the Scatter Chart is the only chart in Excel having both X and Y axes?
0 kommentar(er)
