What is a Scatter Chart in Excel?
Scatter charts are one of the most powerful tools in Excel for visually understanding how two different sets of numbers are related. Whether you're a marketer trying to connect ad spend to sales or a founder looking at user engagement metrics, a scatter chart can reveal patterns you might otherwise miss. This guide will walk you through exactly what a scatter chart is, when to use one, and how to create and customize it step-by-step in Excel.
What is a Scatter Chart?
At its core, a scatter chart (also known as a scatter plot or scatter gram) is a type of graph that displays values for two different numeric variables. Each piece of your data gets represented as a single dot on the chart. One variable's value determines the dot's position on the horizontal axis (the x-axis), and the other variable's value determines its position on the vertical axis (the y-axis).
Think of it like plotting points on a map, but instead of latitude and longitude, you're using your own business data. For example, you could plot your daily advertising spend on the x-axis and the corresponding number of website sign-ups on the y-axis. By looking at the collection of dots that appear, you can quickly see if there's a relationship between the two.
- The Independent Variable: This is the variable you control or change, and it's almost always placed on the horizontal x-axis. In our example, Ad Spend would be the independent variable.
- The Dependent Variable: This is the variable you observe to see if it’s affected by the changes in the independent variable. It goes on the vertical y-axis. Here, Website Sign-ups would be the dependent variable.
By putting all these dots together, you're no longer looking at rows of abstract numbers in a spreadsheet. You're looking at a visual story of your data.
When Should You Use a Scatter Chart?
Scatter charts are incredibly useful for answering specific business questions by identifying patterns in your data. Here are the three most common scenarios where a scatter chart shines.
1. Identifying Relationships and Correlations
This is the primary job of a scatter chart. It helps you see if two variables move in relation to each other. For example, you might want to know:
- Does increasing our Facebook Ad spend lead to more online sales?
- Is there a relationship between the number of sales calls a rep makes and the revenue they close?
- Does a higher product discount correspond with a higher number of units sold?
A scatter chart will visually represent this relationship (or lack thereof) as a pattern. If the dots trend upwards, you have a positive correlation. If they trend downwards, it's a negative correlation. If they're all over the place, there's no correlation.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
2. Detecting Outliers
Outliers are data points that sit far away from the main cluster of dots. These can be just as insightful as the main trend. A scatter plot makes them impossible to miss. Imagine plotting your daily web traffic against sales. You might see an outlier - a day with massive traffic but unusually low sales. This dot, sitting far from the others, prompts an important investigation: "What happened on that day? Was the site down? Was a promotions code broken?"
3. Uncovering Clusters in Your Data
Sometimes, your data points will form distinct groups or clusters on the chart. This can reveal hidden segments in your data. For instance, if you plot average order value against customer age, you might find two separate clusters: one group of younger customers with lower average orders, and another of older customers who consistently spend more. This kind of segmentation is marketing gold, allowing you to tailor your messaging and offers to different groups.
When a Scatter Chart Isn't the Best Choice
While useful, scatter charts aren’t a one-size-fits-all solution. Using the wrong chart can be more confusing than helpful. Here's when to opt for something else:
- To Show Changes Over Time: If your horizontal axis is a time series (days, months, years), a line chart is a much better choice. It connects the dots to clearly show trends over that period.
- To Compare Categories: If you are comparing distinct categories (e.g., sales by product line, traffic from different social media platforms), a bar or column chart is the standard. A scatter chart requires two numeric variables and doesn't handle categorical data well.
- To Understand Composition: If you're trying to show parts of a whole (like the percentage of your budget allocated to different marketing channels), a pie or donut chart is more appropriate.
How to Create a Scatter Chart in Excel: A Step-by-Step Guide
Making a scatter chart in Excel is simpler than it sounds. Let's walk through it with an example looking at the relationship between weekly YouTube ad spend and widget sales.
Step 1: Set Up Your Data
First, organize your data in two columns. The independent variable (what you control, like "Ad Spend") should be in the left column, and the dependent variable (what you're measuring, like "Widget Sales") should be in the right column.
Your data should look something like this:
Step 2: Select Your Data
Click and drag your mouse to highlight both columns of data, including the headers ("Weekly Ad Spend" and "Widget Sales").
Step 3: Insert the Scatter Chart
With your data selected, navigate to the Insert tab on the Excel ribbon at the top of the screen. Look for the Charts group. Click on the icon that looks like a plot of dots - this is the Insert Scatter (X, Y) or Bubble Chart option.
A dropdown menu will appear. For a standard analysis, choose the first option, the basic Scatter chart without any connecting lines.
Step 4: Review Your Basic Chart
And just like that, Excel will drop a scatter chart onto your worksheet! You'll see your data plotted as a series of dots. It's a great start, but to make it truly useful, you'll need to clean it up a bit.
Making Your Scatter Chart Readable and Insightful
A default Excel chart is a good first step, but a few customizations can turn it from a simple graph into a compelling piece of analysis. Here’s how to add polish.
Add a Trendline to Clarify the Relationship
A trendline (or a line of best fit) is a straight line that cuts through the data in a way that best shows the overall trend. It makes recognizing positive or negative correlations much easier.
To add one, single-click anywhere on your chart to select it. A small plus sign ("+") icon will appear in the top-right corner. Click it to open the Chart Elements menu, and then check the box next to Trendline.
Label Your Chart and Axes
A chart without labels is just abstract art. Always give it a descriptive title and label your axes so anyone can understand what they're looking at. In the same Chart Elements menu ("+"), check the boxes for Chart Title and Axis Titles. Then, double-click on the default text boxes to type in your own, such as "Widget Sales vs. Weekly Ad Spend" for the title.
Adjust Your Axes for Better Focus
Sometimes your data points are clustered in a small area of the chart, leaving tons of empty white space. You can "zoom in" on your data by adjusting the range of the axes.
Right-click on the horizontal or vertical axis label and select Format Axis. A panel will appear on the right. Under Axis Options, you can change the Bounds (Minimum and Maximum) to fit your data more tightly. For example, if all your sales numbers are between 50 and 150, you could set the vertical axis minimum to 50 instead of 0.
How to Interpret Your Scatter Chart
You’ve created and formatted your chart. Now for the most important part: what does it mean? Here's how to read the patterns.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Positive Correlation
When the points on the chart trend upwards from left to right, you have a positive correlation. This means that as your x-axis variable increases, your y-axis variable also tends to increase. In our example, an upward trend would suggest that higher ad spend is associated with higher sales.
Negative Correlation
If the dots generally trend downwards from left to right, it indicates a negative correlation. This pattern suggests that as the x-axis variable increases, the y-axis variable tends to decrease. For example, if you plotted "Hours of Employee Training" vs. "Number of Support Tickets," you would hope to see a negative correlation.
No Correlation
When the data points are scattered randomly across the chart with no obvious upward or downward trend, there is likely no correlation between the two variables. The dots will look like they were spattered onto the page at random. This is also a valid insight - it tells you that changing one variable seems to have no predictable effect on the other.
Outliers and Clusters
Don't forget to look for points that don't fit the pattern. That lonely dot far away from the trendline could be a one-time data entry error or an indicator of a special event you need to investigate. Likewise, subgroups of points that are bunched together might show you distinct segments worth exploring further.
Final Thoughts
Learning to use scatter charts in Excel is a fundamental step in becoming more data-savvy. They are simple to create yet powerful enough to reveal important relationships, outliers, and groups within your data, helping you move from guessing to making informed decisions based on what the numbers are actually telling you.
Manually building these charts in Excel works well, but it can become tedious, especially when your most important data lives in different applications like Shopify, Google Analytics, Firebase, or your preferred Customer Relationship Software. We actually built Graphed to solve this headache. Instead of exporting CSVs and fighting with spreadsheets, you can hook up all your data and simply ask questions directly. Graphed connects to dozens of different software systems, and lets customers get real-time answers to key business questions, and build amazing charts for you in about 30 seconds.
Related Articles
Facebook Ads for Carpet Cleaners: The Complete 2026 Strategy Guide
Learn how to run Facebook ads for carpet cleaning businesses in 2026. Get proven strategies for targeting, creative formats, retargeting, and budget that actually convert.
Facebook Ads For Personal Trainers: The Complete 2026 Strategy Guide
Learn how to effectively use Facebook ads for personal trainers in 2026. This comprehensive guide covers targeting strategies, ad creative, budgeting, and optimization techniques to help you grow your training business.
Facebook Ads for HVAC Companies: The Complete 2026 Strategy Guide
Learn how to run high-converting Facebook ads for HVAC companies in 2026. This guide covers targeting, creative strategies, and proven campaigns that drive real leads.