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 .

How to Make an X-Y Scatter Plot in Microsoft Excel. Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers.

Excel 2013 optionally adds a trend line to assist in identifying such trends. A sharp diagonal trend line indicates a correlation between the values, whereas a horizontal line indicates a more ...

The procedure to create a scatter plot in Excel is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Scatter Plot. Select the appropriate Scatter Plot chart.