How to Insert a Scatter Chart in Excel

A scatter chart is one of the most powerful tools in your data analysis toolkit, helping you see the relationship between two different variables at a glance. It's the perfect way to answer questions like, "Does my ad spend actually lead to more sales?" or "Are more experienced employees paid higher salaries?" This guide will walk you through exactly how to create and customize a scatter chart in Excel, so you can move from raw data to clear insights.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Scatter Chart (And When Should You Use One?)

At its core, a scatter chart (also called a scatter plot or XY chart) uses dots to represent the values of two different numeric variables. One variable is plotted along the horizontal axis (the x-axis), and the other is plotted along the vertical axis (the y-axis). Each dot on the chart is a single data point, showing its x and y value simultaneously.

The primary purpose of a scatter chart is to show the correlation - or relationship - between two variables. By looking at the pattern of the dots, you can quickly determine if the variables are related and, if so, how strongly.

Use a scatter chart when you want to:

• Identify potential cause-and-effect relationships: While correlation doesn't equal causation, a scatter chart is often the first step in identifying variables that influence each other.
• Spot correlations: Do sales increase when you spend more on marketing? Does customer satisfaction decrease as wait times go up? A scatter chart makes this visual.
• Find outliers: You can easily see data points that don’t fit the overall pattern. An outlier might represent a wildly successful marketing campaign, a defective batch of products, or a simple data entry error.

Here are a few common business scenarios where a scatter chart is the perfect tool:

• Marketing Analysis: Plotting Ad Spend (X-axis) vs. Sales Revenue (Y-axis) to see if your advertising efforts are paying off.
• Sales Performance: Charting Number of Sales Calls Made (X-axis) vs. Deals Closed (Y-axis) to see if there's a link between activity and results.
• E-commerce Pricing: Comparing Product Price (X-axis) vs. Units Sold (Y-axis) to understand price elasticity.
• Operations: Analyzing Production Time (X-axis) vs. Number of Defects (Y-axis) to identify quality control issues.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Preparing Your Data for a Scatter Chart

Before you can make a chart, you need to set up your data correctly in Excel. This is the most important step, if your data isn’t structured properly, Excel won’t be able to create the chart you want.

For a scatter chart, you need two columns of numerical data, side-by-side. Each row should represent a single "observation" or data point.

• Column 1 (X-axis): This is your independent variable. It's the one you believe might be influencing the other. In our example, this would be "Ad Spend," as we think a change in spending might cause a change in sales.
• Column 2 (Y-axis): This is your dependent variable. Its value potentially "depends" on the first variable. Here, that would be "Sales Revenue."

Here’s how you should structure your data. Let's use the example of tracking monthly ad spend against monthly sales revenue.

Example Data Layout:

1. Month | Ad Spend ($) | Sales Revenue ($)
2. Jan | 500 | 8,500
3. Feb | 750 | 9,200
4. Mar | 1,200 | 11,500
5. Apr | 1,000 | 10,800
6. May | 1,500 | 14,000
7. Jun | 2,000 | 17,500

Make sure your data is clean. Both columns must contain only numeric values. Any text or special characters in the data columns will cause errors.

How to Create a Scatter Chart in Excel: Step-by-Step

Once your data is prepped, creating the basic chart takes only a few clicks. Follow these steps:

1. Select Your Data

Click and drag your mouse to highlight the two columns of numerical data you want to plot. In our example, you would select the data in the "Ad Spend" and "Sales Revenue" columns. It's important not to include the column headers in your initial selection if you have other numerical data columns, though Excel is often smart enough to figure it out.

2. Go to the Insert Tab

At the top of the Excel ribbon, click on the Insert tab.

3. Choose the Scatter Chart Icon

In the "Charts" section of the Insert tab, look for a small icon with dots scattered on it. This is the "Insert Scatter (X, Y) or Bubble Chart" icon. Click it.

A dropdown menu will appear with several chart subtypes. For most purposes, the first option, simply called "Scatter," is the one you want. This will create a basic plot with just markers (dots).

Excel will instantly generate the scatter chart and place it on your worksheet. And that's it! You have a scatter chart. However, in its default state, it’s not very useful. The next step is to customize it to make it readable and insightful.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing Your Scatter Chart for Clarity

A chart without labels is just a collection of dots. To tell a compelling story, you need to add context and highlight the main takeaways.

Click on your new chart to select it. You’ll see a few icons appear on its right side, including a green plus sign ('+'). This is the Chart Elements menu, which is your command center for customization.

Add and Edit Chart & Axis Titles

This is non-negotiable. Your audience needs to know what they're looking at.

1. Click the chart, then click the green '+' icon.
2. Check the boxes for "Chart Title" and "Axis Titles."
3. Click into the new text boxes that appear on your chart to edit them.

• Chart Title: Make it a descriptive summary. Instead of "Chart Title," use something like "Relationship Between Ad Spend and Sales Revenue."
• Horizontal Axis Title (X-axis): Label it clearly. For our example, this would be "Monthly Ad Spend ($)."
• Vertical Axis Title (Y-axis): Label this one as well. In our case, "Monthly Sales Revenue ($)."

Add a Trendline to Show the Relationship

A trendline is a line that cuts through the data points to show the general direction or trend. This is a powerful feature for scatter charts because it visually confirms the correlation.

1. Click the chart, then click the green '+' icon.
2. Hover over "Trendline" and a small arrow will appear.
3. Click the arrow and select "Linear" from the options. A straight line will appear on your chart.

In our example, adding a trendline will show a clear upward slope, visually telling us that as ad spend increases, sales revenue tends to increase as well.

Formatting Colors and Markers

To make the chart visually appealing or match your brand styles, you can change the look.

• Click your chart, and two new tabs, "Chart Design" and "Format," will appear on the Excel ribbon.
• On the Chart Design tab, you can choose from pre-set styles and color palettes.
• To edit the data points themselves, right-click on any dot and select "Format Data Series." A panel will open where you can change the color, size, and shape of the markers.

Interpreting Your Scatter Chart: Reading the Story

Once your chart is created and formatted, the final step is to understand what it’s telling you.

Look at the Direction of the Data Points (Correlation Type)

• Positive Correlation: The points trend upwards from left to right. This means as the X-axis variable increases, the Y-axis variable also tends to increase. Our "Ad Spend vs. Sales Revenue" chart shows a positive correlation.
• Negative Correlation: The points trend downwards from left to right. As the X-axis variable increases, the Y-axis variable tends to decrease. An example might be "Employee Training Hours vs. On-the-Job Accidents."
• No Correlation: The points are scattered randomly across the chart with no discernible pattern. This indicates that the two variables are likely unrelated. For example, plotting "Employee Height vs. Monthly Sales" would probably show no correlation.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Check the Strength of the Relationship

How tightly clustered are the points around the trendline?

• A strong correlation means the points are very close to forming a straight line. The relationship is predictable.
• A weak correlation means the points are more widely scattered, but there is still a visible general trend. The relationship is less predictable.

Find the Outliers

Look for any dots that are far away from the main cluster and the trendline. These are your outliers. An outlier isn't necessarily "bad" data, often, it’s the most interesting point. It could represent:

• An exceptionally successful month where a small ad spend resulted in huge revenue.
• A failed campaign where a large ad spend produced nearly zero return.
• A potential data entry error that needs investigation.

Scatter Chart vs. Line Chart: A Common Mistake

Beginners often confuse scatter charts with line charts because both can show points and lines. However, they serve very different purposes.

• Use a Line Chart to track the change of a single numeric variable over a continuous time period. The X-axis is always a time-series (e.g., days, months, years). Example: Tracking your website traffic each day for a month.
• Use a Scatter Chart to compare two different numeric variables to see if they are related. The x-axis is a numeric variable, not a time category. Example: Comparing visitor traffic to conversion rate on different days.

Using a line chart to show the relationship between ad spend and sales would be incorrect, as it would imply a direct connection between January's ad spend and February's in a way that doesn't make logical sense.

Final Thoughts

Creating a scatter chart in Excel is a straightforward process that transforms two columns of numbers into a powerful visual story. By preparing your data correctly, inserting the chart, and adding key elements like titles and a trendline, you can quickly see the relationship between different parts of your business, helping you make smarter, data-driven decisions.

Manually wrangling spreadsheets and creating charts in Excel is effective for one-off analyses. At Graphed, we help you automate this entire process by connecting directly to tools like Google Analytics, Facebook Ads, Shopify, and Salesforce. Instead of exporting CSVs, you can simply ask questions in plain English - like "create a chart comparing Facebook Ads spend vs. Shopify revenue" - and get a live, interactive dashboard in seconds, not hours.