What are Scatterplots in Excel?

Data Science, AI and ML
,
#1

A scatter plot (also called an XY graph, or scatter diagram) is a two-dimensional chart that shows the relationship between two variables. In a scatter graph, both horizontal and vertical axes are value axes that plot numeric data.

  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.