Scatter Plot in Excel
A Scatter plot consists of data points plotted on a two-dimensional coordinate system, with one variable represented on the x-axis (horizontal) and the other on the y-axis( vertical). Typically, the independent variable is on the x-axis, and the dependent variable is on the y-axis. The chart displays values at the intersection of an x and y axis, combined into single data points.
The main purpose of a scatter plot is to show how strong the relationship, or correlation between the two variables is.
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: