A Scatter Plot is one of the best visualization designs you can use to display causal relationships between two key data variables.
Why?
The chart uses a series of dots to display insights into two varying sets of data. So decoding the Scatter Plot is amazingly easy, even for non-technical audiences (and readers).
If your goal is to display relationships and associations between variables, we suggest you give a Scatter Plot a try. There’re three types of relationships that a Scatter Plot Chart displays, namely:
So how can you generate visually stunning and insightful Scatter Plots for your data stories?
Excel seems to be the logical choice for many because it has been there for years. However, the tool produces less desirable charts, which require extra time and effort to customize.
You don’t have to waste your valuable time.
You have an option of installing a particular third-party application (add-in) if your goal is to access ready-to-use Scatter Plot Charts.
In this blog, you’ll learn:
Before diving right into the how-to guide, let’s define the visualization design.
A Scatter Chart (also known as Scatter Plot or Scatter Diagram is a visualization design that uses Cartesian coordinates to display insights into varying sets of data.
The chart uses dots to display relationship between variables.
The Scatter Plot communicates insights using dots or markers between its x and y-axes. Essentially, each of the chart’s dots appears “scattered” hence its name. You can use Scatter Plot to determine the causal effect relationship between key data points.
For instance, you can use the visualization design to track the relationship between age, height and weight.
Take a look at the tabular data below.
Can you provide meaningful insights into the data (below)?
Age | Height (inches) | Weight (lbs.) |
3 | 27.6 | 13 |
4 | 28.8 | 18 |
5 | 30 | 20 |
6 | 36 | 17 |
7 | 38.4 | 15 |
8 | 34.8 | 19 |
9 | 48 | 25 |
10 | 54 | 32 |
11 | 45.6 | 38 |
12 | 3.8 | 40 |
13 | 60 | 34 |
14 | 68.4 | 45 |
Note the difference after visualizing the data using the Scatter Plot.
You’ll agree that the data (in the table above) is now in a form that’s easy to interpret.
Let’s interpret the chart (above).
The relationship between the height and age of the children is positive. And this means the height of the children increases with age.
How to make a Scatter Plot in Excel with two sets of data should never be a time-intensive affair. Keep reading to discover more.
A Scatter Plot is a visualization design that uses a series of dots to display hidden relationships between key data points. You can use the chart to visualize two varying data sets for in-depth insights.
The chart is best-suited in displaying causal relationships in raw data.
Furthermore, you can use a Scatter Graph for the following:
How to make a Scatter Plot in Excel with two sets of data should never overwhelm you. Keep reading to discover more.
As we said earlier, freemium data visualization tools, such as Excel, come with pretty basic Scatter Plot examples. And this means you need to rework these charts, which means additional time spent.
If you feel you’ve outgrown the basic charts offered by Excel give ChartExpo a try.
Why?
ChartExpo is an add-in you can install in Excel to access advanced Charts, such as Scatter Plot.
More so, the visualization tool produces ready-made and visually stunning charts. ChartExpo has 50-plus advanced charts you’ll never find in freemium data visualization tools, such as Excel. You don’t need to learn programming or coding to use ChartExpo. Yes, it’s that easy to use this highly intuitive tool.
So how can you install ChartExpo in Excel?
Here is the complete step-by-step guide on how you can install ChartExpo add-in for the Excel application.
To get started with the Scatter Plot in Excel, follow the steps below:
How to make a Scatter Plot in Excel with two sets of data should never be a stressful affair for you. Keep reading to discover more.
We’ll use a Scatter Plot to visualize the tabular data below for insights in this example.
Products Type | Products | Profit | cost | no. of orders |
Cosmetic | Face Primer | 15.79 | 90 | 10 |
Cosmetic | Foundation | 20.13 | 70 | 12 |
Cosmetic | Concealer | 38.62 | 190 | 9 |
Cosmetic | Blush | 34.62 | 880 | 16 |
Cosmetic | Highlighter | 71.84 | 900 | 22 |
Cosmetic | Bronzer | 71.84 | 600 | 23 |
Cosmetic | Powder | 32.77 | 600 | 42 |
Cosmetic | Eye Primer | 21.8 | 1300 | 19 |
Electronics | TVs | 110 | 590 | 28 |
Electronics | refrigerators | 12.61 | 390 | 11 |
Electronics | washing machines | 70.21 | 490 | 41 |
Electronics | air conditioners | 70.21 | 390 | 18 |
Electronics | printers | 68.83 | 260 | 17 |
Electronics | speakers | 17.55 | 210 | 2 |
Electronics | keyboards | 54.74 | 170 | 23 |
Electronics | e-readers | 12.66 | 170 | 13 |
The primary use of Scatter Charts is to draw insights into two variables.
The independent variable is depicted by the y-axis, while the dependent one is represented by the horizontal line (x-axis). The position of the dots relative to either axis determines the nature of the relationship.
Check out the common uses of a Scatter Plot below.
Seasoned data visualization experts use a Scatter Plot to display the causal relationships between two variables. The relationship between variables can be positive or negative, non-linear or linear, or strong or weak.
You can use this insightful chart to uncover hidden correlational relationships in your raw business data.
Use a Scatter Plot to identify the general trend of your key variables in your raw data.
Data points in this chart are grouped together based on how close their values are, making it easier to identify outliers. You don’t want to base your business decisions on outliers because they can be misleading.
Interestingly, the nature of the correlations can also be estimated based on a specified confidence level.
A positive correlation depicts an uptrend. Essentially, in a Scatter Plot with a positive correlation, data points slope upwards from the lower-left corner of the chart towards the upper-right.
On the other hand, the negative correlation depicts a downtrend. Key data points slope downwards from the upper-left corner of the chart towards the lower-right. Data that are neither positively nor negatively correlated is considered uncorrelated (null).
How to make a Scatter Plot in Excel with two sets of data should never throw a curveball at you. Keep reading to discover more.
Each chart and graph you use to visualize raw data has its own strengths and weaknesses. A Scatter Chart is not an exception.
Let’s go through its advantages
Scatter charts are incredibly crucial, especially if your goal is to display correlational insights. You can use this chart to uncover and reveal the correlation between key metrics in your data.
Data visualization experts consider a Scatter Plot an apt visualization design to show the non-linear and non-linear relationship in data. Scatter Plot Charts are amazingly easy to read, even for non-technical audiences.
The range of flow of data in Scatter Plot examples is readily visible. And this means you can easily point out the maximum and minimum points in your data at a snap of the fingers.
It gives you the exact data points and values in the graph distributed accordingly on the chart.
A Scatter Plot shows the relationship between two quantitative variables in a data set. The values of the dependent variable appear on the horizontal axis, while independent variables appear on the vertical axis of the chart.
Use the chart if your goal is to uncover hidden relationships of key data points.
A Scatter Plot is widely used to visualize ordered pairs of data. For instance, you can use the visualization design to display insights into two varying data sets, such as height and age.
Also, you can use a Scatter Graph to display causal-effect associations in your data.
Scatter Plot Graphs are among the best charts to use to display relationship insights into two varying data variables.
And this is because the chart uses a series of dots to display insights into two varying data sets. So decoding the Scatter Plot is amazingly easy, even for non-technical audiences (and readers).
If your goal is to display relationships and associations between variables, we suggest you give a Scatter Plot Graph a try.
So how can you generate ready-made and visually stunning Scatter Plots?
Excel seems to be the logical choice, especially among small and medium-sized businesses (SMB). However, the spreadsheet application in question generates pretty basic Scatter Plots, which take a ton of time to customize.
So which Scatter Plot maker do you recommend?
We recommend you install third-party apps, such as ChartExpo, to access advanced charts. This easy-to-use data visualization tool comes as an add-on you can easily download and install in your spreadsheet app.
ChartExpo comes loaded with insightful and easy-to-interpret Scatter Diagrams, plus over 50 more charts. Besides, you don’t need programming or coding skills to visualize your data using the Scatter Plot generator.
How to make a Scatter Plot in Excel with two sets of data should never consume your valuable time.
Sign up for a 7-day free trial today to access ready-made and crystal-clear Scatter Plots for your data stories.
We will help your ad reach the right person, at the right time
Related articles