How do I make a scatter plot in Excel 2016?

Create a scatter chart

1. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data you want to plot in a scatter chart.
2. Select the data you want to plot in the scatter chart.
3. Click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.
4. Click Scatter.

How do you do a scatter plot?

Scatter Diagram Procedure

1. Collect pairs of data where a relationship is suspected.
2. Draw a graph with the independent variable on the horizontal axis and the dependent variable on the vertical axis.
3. Look at the pattern of points to see if a relationship is obvious.
4. Divide points on the graph into four quadrants.

How do you construct a scatter plot?

Basic Scatter Plot. To create a scatter plot, choose the X-Variable (the horizontal variable) and the Y-Variable (the vertical variable) from the lists at the right, the press the “Update” button. The scatter plot will appear in the center.

How do you make a scatter graph in Excel?

Steps to create excel scatter plots: Select all the cells that contain data. Click on Insert tab. Look for Charts group. Under Chart group, you will find Scatter (X, Y) Chart. Click the arrow to see the different types of scatter and bubble charts.

When to use scatter plots?

A scatter plot can be used either when one continuous variable that is under the control of the experimenter and the other depends on it or when both continuous variables are independent.

What is a scatter diagram in Excel?

A scatter plot is a built-in chart type in Excel meant to show the relationship between two variables. A scatter plot works by placing one variable on the vertical axis and a different variable on the horizontal axis. Each piece of data is then plotted as a discrete point on the chart.