How to create a Scatter Plot in Excel 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.

Alternatively, you could create a column chart. The procedure is similar to that for a bar graph as explained earlier, however, this time select Insert > Column and then choose the chart type.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.