A Step-by-Step Guide to Making a Scatter Plot in Excel

Making a scatter plot in Excel is a great way to visualize data gain insights into trends relationships between two variables. Scatter plots are used to show the relationship between two variables such as the relationship between sales profits. In this guide we’ll walk you through the steps of creating a scatter plot in Excel.

Step 1: Prepare Your Data

The first step in creating a scatter plot in Excel is to prepare your data. You’ll need two columns of data one for each variable. Make sure that the data is in numerical form that the two columns are labeled appropriately.

Step 2: Select Your Data

Once your data is prepared select the two columns of data. You can do this by clicking dragging your mouse over the two columns.

Step 3: Insert the Scatter Plot

Now that your data is selected you can insert the scatter plot. To do this go to the Insert tab select the Scatter chart option.

Step 4: Customize Your Scatter Plot

Once your scatter plot is inserted you can customize it to your liking. You can change the colors add labels adjust the axes.

Step 5: Analyze Your Data

Once your scatter plot is customized you can analyze your data. Look for trends relationships between the two variables.

Conclusion

Creating a scatter plot in Excel is a great way to visualize data gain insights into trends relationships between two variables. With this guide you should now have the knowledge to create a scatter plot in Excel.