A scatter plot is just one style of chart-making in Excel. If you find that you need more flexibility in the presentation, you can right-click on the chart and select Change chart type .

In the case of a scatter plot, whether you use it simply with marking points or lines, the graph is spread across the XY-axis. Eg. Let us consider this example of a person’s salary across the ...

Excel automatically distributes these points along a uniform X axis. To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data.

How to Make a Scatterplot on Excel. 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.

The graph shows that the more one studies (X-axis), the higher one will score on a test (Y-axis). The scatter plot allows you to add trend lines, which help predict data patterns and validate the ...