An X-Y scatter chart is an ideal plot choice when you have data sets with at least two interesting variables per record, and because scatter plots are a native graph option in Excel, you simply ...

A scatterplot chart graphs two related data values as a single dot by plotting one value on the horizontal X axis and the other value on the vertical Y axis. For example, you could plot an ...

You must specify one or more x -axis variables and one or more y -axis variables. For three-dimensional plots, you must specify one or more z -axis variables. For a two-dimensional scatter plot, ...

The points to plot are (21, 70), (26, 86), (15, 50) etc. Note the jagged lines close to the origin. These indicate a broken scale. A broken scale is used when values close to 0 are not required.