How to Create a Scatterplot in Excel

Creating a scatterplot in Excel is one of the most practical skills a data analyst — or really anyone working with numbers — can develop. Whether you’re mapping sales performance against advertising spend, visualizing the relationship between temperature and energy consumption, or simply trying to spot trends hiding in a spreadsheet, a scatterplot cuts through the noise and makes patterns visible at a glance.

Excel makes this process surprisingly straightforward, even for users with limited experience. With just a few clicks, raw data transforms into a clear, readable chart that can inform decisions, support arguments, and communicate findings far more effectively than a wall of numbers ever could.

What is a Scatterplot in Excel?

A scatterplot — sometimes called a scatter chart or XY chart — is a type of graph that displays data points plotted along two axes. Each point represents a single observation, with its horizontal position determined by one variable and its vertical position determined by another. The resulting pattern of dots reveals whether a relationship exists between the two variables and, if so, what kind.

In Excel, scatterplots are built using the XY (Scatter) chart type, which is specifically designed for this purpose. Unlike a line chart, which assumes your data points are evenly spaced and connected in sequence, a scatterplot treats each data pair independently — making it the right tool whenever you want to explore correlation rather than track change over time.

Scatterplots are widely used across fields: scientists use them to test hypotheses, marketers use them to measure campaign effectiveness, and financial analysts use them to compare asset performance. Their strength lies in simplicity — a well-constructed scatterplot can reveal a strong correlation, a weak one, or no relationship at all, giving you an honest picture of what your data actually shows.

Preparing Your Data

Before you can build a scatterplot, your data needs to be organized in a way Excel can read correctly. Taking a few minutes to set this up properly will save you frustration later and produce a cleaner, more accurate chart.

Arrange data in two columns Excel expects your data in two adjacent columns — one for each variable. The left column typically holds the independent variable (the one you’re treating as the cause or input), and the right column holds the dependent variable (the outcome or result you’re measuring).

Add clear column headers Label each column at the top with a short, descriptive heading. Excel will automatically pull these labels into your chart as axis titles, so accurate headers mean less manual editing afterward.

Check for consistency Every row should contain a complete data pair. Remove or address any blank rows, missing values, or obvious errors before building your chart, as these can distort the plot or cause Excel to misread your data range.

Use numbers, not text Scatterplots are built from numerical data. If your spreadsheet contains values stored as text — a common issue when importing data from external sources — convert them to numbers first. Excel will not plot text values, and may silently skip those rows without warning you.

Keep your data in one block Avoid gaps or unrelated content within your data range. Excel selects data based on contiguous cells, so any interruption in your table may cause it to capture the wrong range when you go to build the chart.

Step-by-Step: How to Create a Scatterplot in Excel

Step 1: Select Your Data Click the header of your first column, then drag to select all the data in both columns, including the headers. Make sure you’re capturing every row you want to include in the chart — double-check that no rows are missing and no extra blank rows are selected at the bottom.

Step 2: Open the Insert Tab With your data selected, navigate to the Insert tab in Excel’s ribbon toolbar at the top of the screen.

Step 3: Find the Charts Group Within the Insert tab, look for the Charts group. You’ll see several chart type icons displayed here. Find the one labeled Scatter (it may appear as a small grid of dots), and click on it to open a dropdown menu.

Step 4: Choose Your Scatter Chart Style The dropdown will display several scatterplot variations. For a standard scatterplot, select Scatter with Only Markers — the first option in the list. This produces a clean plot with no connecting lines, which is the most common format for visualizing correlation.

Step 5: Review the Initial Chart Excel will instantly generate a scatterplot and place it on your worksheet. Take a moment to review it. Check that the axes reflect the correct variables, that the number of data points looks right, and that nothing appears obviously wrong before moving on to formatting.

Step 6: Move the Chart if Needed By default, Excel places the chart on top of your data. Click and drag it to an open area of the worksheet, or right-click the chart and select Move Chart to place it on a dedicated chart sheet — a cleaner option if you plan to present or share the chart on its own.

How to Add a Trendline in Excel

Step 1: Click on Your Chart Select your scatterplot by clicking anywhere inside it. This activates the chart and makes the Chart Elements options available.

Step 2: Add the Trendline Click the small green plus icon ( + ) that appears at the top-right corner of the chart. This opens the Chart Elements menu. Check the box next to Trendline, and Excel will immediately draw a linear trendline through your data points.

Step 3: Choose a Trendline Type For most purposes, a linear trendline works well — it draws a straight line that best fits your data. However, if your data follows a curve, Excel offers additional options. Hover over the Trendline checkbox and click the arrow that appears to access these choices:

• Linear — best for data with a steady, consistent direction
• Exponential — suited for data that rises or falls at an increasing rate
• Logarithmic — useful when growth is rapid at first, then levels off
• Polynomial — handles more complex curves with multiple bends
• Power — works well for data that increases at a consistent rate relative to a power
• Moving Average — smooths out short-term fluctuations to highlight longer trends

Step 4: Display the Equation and R² Value For a more informative chart, right-click the trendline and select Format Trendline to open the formatting panel. Near the bottom, check Display Equation on Chart and Display R-squared Value on Chart. The equation describes the mathematical relationship between your variables, while the R² value — ranging from 0 to 1 — tells you how well the trendline fits your data. A value close to 1 indicates a strong fit.

Step 5: Format the Trendline Also within the Format Trendline panel, you can adjust the line’s color, weight, and style to make it stand out clearly against your data points. A contrasting color — red against blue data points, for example — helps readers distinguish the trendline immediately.

Formatting and Improving Your Scatterplot

A well-formatted scatterplot is easier to read, more professional in appearance, and more persuasive in a presentation or report. Excel gives you extensive control over every visual element of your chart. Here’s how to make the most of it.

Add or Edit Axis Titles Click the chart, then click the green plus icon in the top-right corner to open the Chart Elements menu. Check the Axis Titles box to add labels to both axes. Double-click each title to edit it, and replace the placeholder text with a clear, descriptive label that includes the unit of measurement where relevant — for example, “Monthly Revenue (USD)” or “Temperature (°C).”

Edit the Chart Title Excel generates a default chart title automatically. Double-click it to replace it with something specific and meaningful. A good chart title tells the reader exactly what the chart shows — “Advertising Spend vs. Sales Revenue, Q1–Q4 2024” is far more useful than “Chart 1.”

Adjust Axis Scales If your data points are clustered in one corner of the chart, the default axis scale may be leaving large areas of empty space. Right-click either axis and select Format Axis to manually set the minimum and maximum values. Tightening the scale around your data range makes patterns easier to see.

Change Data Point Appearance Right-click any data point and select Format Data Series to open the formatting panel. Here you can change the shape, size, and color of your markers. Larger markers are easier to spot in a dense plot, while a distinctive color helps your data stand out against the white chart background.

Add Data Labels If your scatterplot has a small number of data points and you want to identify each one, click the plus icon and check Data Labels. You can then format the labels to display the data values, the series name, or custom text pulled from another column in your spreadsheet — useful when each point represents a named category, such as a country, product, or team member.

Remove Gridlines if Needed Gridlines can aid readability in a dense chart, but in a simpler plot they can add visual clutter. Click the plus icon and uncheck Gridlines to remove them, or click directly on a gridline in the chart and press Delete.

Apply a Chart Style For a quick visual upgrade, click the paintbrush icon that appears to the right of your chart when it is selected. Excel offers a range of preset styles and color schemes that change the overall look of the chart in one click. These are a useful starting point, though manual adjustments will usually produce a more polished result.

Resize the Chart Click the chart to select it, then drag any of the handles on its edges or corners to resize it. A wider chart gives your horizontal axis more breathing room, while a taller chart makes vertical differences between data points more visible.

FAQs