As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Create a Scatter Plot in Excel: Step-by-Step Guide

A scatter plot is a powerful visualization tool that depicts the relationship between two variables. Here's a step-by-step guide on creating a scatter plot in Microsoft Excel.

Step 1: Open Excel

Open Microsoft Excel. If you don't have Excel installed, you can download a free trial from Microsoft.com. Once Excel is open, create a new workbook by clicking on the "File" tab and then selecting "New."

Step 2: Enter the Data

Enter the data you want to use for the scatter plot. For this example, consider the following data:

  • X-axis: 1, 2, 3, 4, 5
  • Y-axis: 2, 4, 6, 8, 10

Type "X-axis" in cell A1, "Y-axis" in cell B1, and input the corresponding data in cells A2 through A6 and B2 through B6.

Step 3: Select the Data

Click on cell A1, then drag the mouse down to cell B6. This will highlight all the cells containing your data.

Step 4: Insert the Scatter Plot

Navigate to the "Insert" tab and click on the "Scatter" button. In the drop-down menu, choose the first option, "Scatter with Only Markers." This will insert a basic scatter plot without lines connecting the data points.

Step 5: Customize the Scatter Plot

Customize the scatter plot to suit your preferences. Click on the "Design" tab and use the options in the "Chart Layouts" group. You can add a trendline or change the chart type.

To further customize elements like data labels, axes, etc., click on the "Format" tab. Utilize the options in the "Current Selection" group to format specific elements of the scatter plot.

Step 6: Save the Workbook

Once satisfied with the scatter plot, save the workbook. Click on the "File" tab, select "Save As," choose a location, and give the workbook a name. Ensure the file format is ".xlsx" before saving.