How to Make a Scatter Plot

A scatter plot is one of the simplest yet most powerful ways to see if two things are related to each other. By mapping out your data points as a collection of dots, you can spot trends, identify outliers, and uncover hidden relationships almost instantly. This guide will walk you through exactly what a scatter plot is, when to use one, and how to create your own in popular tools like Google Sheets, Excel, Power BI, and Tableau.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Scatter Plot and Why Use One?

At its core, a scatter plot (or scatter diagram, or X-Y graph) displays values for two different variables as points on a graph. One variable goes on the horizontal X-axis, and the other on the vertical Y-axis. The goal is to see if there's a relationship, or correlation, between them.

Imagine you're tracking how much you spend on social media ads and the resulting website traffic. A scatter plot quickly shows you if spending more money actually leads to more visitors. Each dot on the plot would represent a specific campaign or time period, showing its spend on one axis and its traffic on the other.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding Correlation

By looking at the pattern of the dots, you can typically identify three types of relationships:

• Positive Correlation: As one variable increases, the other variable also tends to increase. The dots will form a pattern that slopes upwards from left to right. Example: The more hours you study for a test (X-axis), the higher your test score is likely to be (Y-axis).
• Negative Correlation: As one variable increases, the other variable tends to decrease. The dots form a pattern that slopes downwards from left to right. Example: The more miles you run (X-axis), the less you weigh (Y-axis).
• No Correlation: There is no apparent relationship between the two variables. The dots are scattered randomly with no clear upward or downward trend. Example: A person's shoe size (X-axis) has no relationship to their SAT score (Y-axis).

Scatter plots are also fantastic for spotting outliers - data points that are way off from the general pattern. An outlier could represent an anomaly, a fluke, or a piece of data worth investigating further. Maybe one ad campaign was a massive success or a total failure compared to the others, a scatter plot makes that jump out immediately.

When Should You Use a Scatter Plot?

You can use a scatter plot any time you have two numeric variables and you want to see if one has an impact on the other. It's incredibly versatile for many business functions.

• Marketing Analysis: Is there a relationship between ad spend and conversions? Do more impressions lead to more website clicks? How does email open rate affect the final sales numbers from a campaign?
• Sales Analytics: Do sales reps who make more calls a day close more deals? Is there a link between the size of a deal and how long it takes to close?
• E-commerce Management: How does the number of product images on a page correlate with that product’s daily sales? Is there a relationship between price and average customer rating?
• Financial Analysis: Understanding the relationship between a company's revenue and its stock price.
• Operations: Does higher factory temperature correlate with a higher number of manufacturing defects?

The key is trying to prove or disprove a hunch. If you think variable A might influence variable B, a scatter plot is your first stop for visual evidence.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Make a Scatter Plot: Step-by-Step Guides

Building a scatter plot is straightforward in most data tools. Let's look at how to do it in some of the most common ones.

How to Make a Scatter Plot in Google Sheets

Google Sheets is perfect for quick and easy scatter plots.

1. Prepare Your Data: Put your data into two columns. The first column (Column A) will be your X-axis variable (the independent variable), and the second column (Column B) will be your Y-axis variable (the dependent variable).
2. Highlight Your Data: Click and drag to select both columns of data, including the headers.
3. Insert the Chart: Go to the menu and click Insert > Chart.
4. Select Chart Type: Google Sheets is pretty smart and will often default to a scatter chart if your data fits. If it doesn't, go to the "Chart type" dropdown in the Chart editor on the right and select "Scatter chart."
5. Customize: Use the "Customize" tab in the Chart editor to add a chart title, label your horizontal (X) and vertical (Y) axes, and tweak the colors or style. Clear labels are essential for anyone else to understand your chart.

How to Make a Scatter Plot in Microsoft Excel

The process in Excel is very similar to Google Sheets.

1. Organize Data: Just like in Sheets, organize your data into two adjacent columns. The left column for the X-axis and the right for the Y-axis.
2. Select Data: Highlight the data cells you want to graph.
3. Insert Your Chart: Navigate to the Insert tab on the ribbon. In the "Charts" section, click the icon that looks like a plot with dots on it. This is the "Insert Scatter (X, Y) or Bubble Chart" menu.
4. Choose the Scatter Type: From the dropdown, select the first option, which is a standard scatter plot without any connecting lines.
5. Customize and Add Elements: Once the chart appears, you can customize it. Click on the chart, and a plus sign (+) will appear next to it. You can use this to add "Axis Titles," a "Chart Title," and even a "Trendline" to help visualize the correlation.

How to Make a Scatter Plot in Power BI

For more interactive analysis, Power BI is a great choice.

1. Load Your Data: First, ensure your data is loaded into Power BI Desktop.
2. Select the Scatter Chart Visual: In the "Visualizations" pane, click on the scatter chart icon (it looks like a set of scattered dots). An empty chart template will appear on your canvas.
3. Assign Your Data to Axes: From the "Fields" pane, drag the numeric field you want on the X-axis and drop it into the "X Axis" box in the Visualizations pane. Do the same for your Y-axis field, dragging it into the "Y Axis" box.
4. Add Delineating Details: At this point, you'll likely only see one dot, a summary of all your data. To plot each individual data point, you must add a category to break it down. Drag a field that's unique to each row (like a "Campaign Name", "Product ID", or "Date") into the "Details" field. The single dot will now “scatter” into many points for each category.
5. Format Your Visual: Click the "Format your visual" tab (a paintbrush icon) to customize everything from the marker shapes and colors to the titles and axis labels. You can also add an "Analytics" line (a trend line) from this pane to make the relationship clearer.

How to Make a Scatter Plot in Tableau

Tableau is another powerful BI tool for creating detailed scatter plots.

1. Connect to Your Data: Start by connecting Tableau to your data source.
2. Set Up Columns and Rows: Tableau uses a concept of "Shelves." Drag your first numeric metric (your independent variable) from the "Measures" pane on the left and drop it onto the "Columns" shelf at the top. This sets your X-axis.
3. Drag Your Second Metric: Drag your second numeric metric (your dependent variable) and drop it onto the "Rows" shelf. This sets your Y-axis.
4. Disaggregate the Data: You'll see a single point, just as in Power BI. This point represents the sum or average of all your data. To see the individual data points, you need to break down the view. The easiest way is to drag a "Dimension" (like "Order ID" or "Customer Name") onto the "Detail" shelf in the Marks card. Alternatively, you can go to the Analysis menu and uncheck "Aggregate Measures."
5. Customize: Use the options in the "Marks" card to change the color, shape, and size of your dots. You can, for instance, drag another dimension (like "Region") to the "Color" shelf to visually segment your data points.

Best Practices for Creating Useful Scatter Plots

• Always Label Your Axes and Title Your Chart: Your chart is useless if no one knows what they're looking at. Clearly label the X and Y axes (including units like $, %, etc.) and give the overall chart a descriptive title (e.g., "Impact of Ad Spend on Website Traffic").
• Add a Trendline When It Helps: A trendline (or line of best fit) can make the underlying relationship much clearer, especially if your data is noisy. Just be careful not to imply a strong relationship where a very weak one exists.
• Remember: Correlation Isn't Causation: This is a classic mantra in analytics. Just because two variables move together doesn't mean one is causing the other. There could be a third, unobserved factor at play. For example, ice cream sales and shark attacks are positively correlated, but that's because both increase in the summer, not because ice cream causes shark attacks.
• Know When a Plot is Too Crowded: If you have thousands of data points, your scatter plot might turn into an unreadable blob. In these cases, you might consider taking a random sample of your data or using a different visualization like a heatmap to show density.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Final Thoughts

Creating a scatter plot is a fundamental skill in data analysis. It provides an immediate visual summary of the relationship between two variables, making it easier to spot patterns and communicate insights than wading through a spreadsheet of numbers. By following the steps for tools like Excel, Google Sheets, Power BI, and Tableau, you can start building powerful charts in minutes.

To speed this process up even further, we built Graphed to remove the manual steps entirely. Instead of clicking through menus and dragging fields, you can connect your data sources (like Google Ads, Shopify, or Salesforce) and simply ask for what you need in plain English. A prompt like, create a scatter plot showing cost vs. total conversions for my campaigns last month will instantly generate a live, interactive chart for you. It handles all the data pulling and visualization building in seconds, allowing you to move straight to the insight.