Scatter plots are often used to show the relationship between two variables. They’re very commonly used in statistics, but you don’t have to draw them from scratch. Let’s learn how to make a scatter plot in Microsoft Excel.
How to Create a Scatter Plot in Microsoft Excel
Scatter plots measure the correlation between two variables. To illustrate this easily, let’s consider a real-world example. Look at a list of two data sets like the one below.
Column A measures annual revenues, while Column B represents the opening of new retail stores. Logically, when the first increases, the second will as well. But a scatter plot lets you test, and illustrate, this hypothesis quickly.
Begin by highlighting the data range in Excel, in this case, cells A1:B5. Then, find the Insert tab on Excel’s ribbon. In the Charts section, find the X Y (Scatter) icon and click on it. From the dropdown, choose the first Scatter option.
Excel will automatically create a scatter plot and add it to your worksheet. Each axis will automatically adapt to fit your data. But you can also customize the layout to better fit your needs.
How to Style Scatter Plots in Microsoft Excel
Excel, as you’ve seen, will create a scatter plot with just a few clicks. But you can quickly apply a few edits to make it your own. Start by adding a chart title. Highlight the Chart Title placeholder, then type in your own words.
You can also apply style effects to change up the look and feel of the scatter plot. With the plot selected, go to the Chart Design section of the ribbon. In the middle, you’ll see a variety of layout thumbnails.
Click on any of them to apply new designs to your scatter plot. In a few clicks, you can create a truly unique scatter plot perfect for your use.
Excel makes scatter plot creation a breeze with pre-built features. They help you explore your data quickly.
Regression in Excel