To make an Excel scatter plot from a table, select the two columns containing your numeric X and Y values, then choose Insert > Insert Scatter (X, Y) or Bubble Chart and pick a scatter style. Excel plots the first column on the horizontal axis and the second on the vertical axis; add a clear title and check that the axes represent the variables you intend.
What an Excel scatter plot shows
A scatter plot, also called an XY chart, places each row of paired data at a position defined by two numerical values. If a row contains a temperature of 18 degrees and a sales total of 42, for example, Excel plots one point at X = 18 and Y = 42. The overall pattern can help you see whether the variables move together, whether values cluster, and whether any observations sit far from the others.
Unlike a typical line chart, a scatter plot uses a value axis for both dimensions. The horizontal gaps between points therefore reflect differences in their X values. This matters when the measurements are irregularly spaced: values at 2, 5, and 20 do not appear at equal intervals. A scatter chart is useful for measurements such as height and weight, advertising spend and sales, or time and distance when the X values are numerical measurements rather than labels.
Prepare the table before charting
Arrange the data in columns with one observation per row. Use a descriptive heading at the top of each column, such as Hours studied and Exam score. Put the independent or explanatory variable—the value you want on the horizontal axis—in the left column, and the paired response value in the column beside it. Keep each row’s pair together; sorting just one column can break the relationship between observations.
- Use numbers for both variables. Values that look numeric but are stored as text may not plot as expected.
- Keep units consistent within each column. Convert minutes to hours, for example, rather than mixing the two.
- Remove explanatory notes and subtotal rows from the selected data range, or keep them outside the table.
- Use a header row so the series can inherit a meaningful name instead of a generic label.
An Excel Table is optional, but it can make the source easier to manage. To create one, click inside the data and choose Insert > Table, confirm the range, and indicate whether it has headers. A table helps keep headings and records together as you add data. A plain rectangular range works for making a chart too.
Create the scatter plot from the table
- Select the two data columns, including their headings. If the columns are next to each other, drag across the heading and data cells. Avoid selecting unrelated columns or totals.
- Choose Insert > Insert Scatter (X, Y) or Bubble Chart on the ribbon.
- Choose Scatter for points without connecting lines. Excel inserts a chart based on the selected cells.
- Click the chart title and type a useful description. Include enough context to identify the variables, such as Study Hours and Exam Scores.
- Check the axes and a few plotted points against the source rows. If the chart has the wrong orientation or values, edit its series rather than assuming the visual is correct.
Excel offers scatter styles with markers only, straight lines, and smooth lines. For an ordinary relationship chart, markers without lines are often the clearest starting point. Connecting lines imply an order or path between observations, so use them only when that connection is meaningful. The exact appearance of the ribbon can vary slightly with window size, but the scatter-chart command is on the Insert tab in Excel for Microsoft 365 on Windows.
Choose the right scatter style and axis scale
Choose a markers-only chart when each row is an independent observation—for instance, a set of product prices and sales quantities. A straight-line or smooth-line scatter chart can suit a sequence such as a sensor reading over time, where connecting successive observations has meaning. Smooth lines are visual interpolation, not additional measurements, so they should not be mistaken for observed data.
Axis limits can change how a pattern looks. Excel may choose minimum and maximum values automatically. To inspect or change them, right-click an axis, choose Format Axis, then review Axis Options. Setting a minimum above zero can make small differences easier to see, but it can also exaggerate those differences. Keep the scale appropriate to the question and make nonzero starting points apparent to readers. Add axis titles through the chart’s Chart Design > Add Chart Element > Axis Titles controls, where available in the ribbon layout, or use the chart elements button beside the selected chart.
Fix the X and Y values or add a series
If Excel has assigned the wrong columns, click the chart and choose Chart Design > Select Data. In the Select Data Source dialog, select a series and choose Edit. Set Series X values to the cells for the horizontal variable and Series Y values to the matching vertical-variable cells. Select only the data cells for these fields, not the heading cells, and make sure the X and Y ranges contain the same number of rows. Set the series name to its heading cell if needed.
To put another group on the same axes, use Chart Design > Select Data > Add, then provide the new series name and its X and Y ranges. For a fair comparison, the series should use compatible units and scales. A new series can have its own X values; it does not have to share the first series’ exact observations. If one group uses a vastly different scale, consider whether a separate chart would communicate the comparison more honestly than adding a secondary axis.
Format labels, markers, and gridlines
Formatting should make the data easier to read, not decorate it at the expense of clarity. Use distinct marker colors or shapes when comparing a small number of groups, and keep the legend only if it helps identify them. A chart title names the comparison, while axis titles communicate the variable and unit—for example, Distance (km) and Elapsed time (minutes). The unit belongs in the label because a number alone may be ambiguous.
Data labels can be useful when there are only a few points or when readers need to identify individual observations. With many points, labels often overlap and obscure the pattern. To add them, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a position. You can also right-click a series to access formatting options for its markers and lines. Retain light gridlines if they help readers estimate values; remove excess visual elements that compete with the points.
What happens when the table grows?
When a chart is based on an Excel Table, adding a row directly below the table normally expands the table, and charts using its data can include the new row. Check the chart after adding data, particularly if the series was manually edited or the chart was created from only part of the table. A chart made from a fixed ordinary cell range will not necessarily include values entered beyond that range. In that case, use Chart Design > Select Data to adjust the series ranges, or create the source as a table and build the chart from its columns.
New records still need valid paired values. A row with an X value but no Y value cannot show a complete point. Excel’s treatment of blanks can depend on chart settings and the chart type; inspect the result rather than assuming a blank is equivalent to zero. Zero is a real plotted value, not a harmless substitute for missing data.
Common problems and what they mean
- The chart shows one point or no useful pattern: Check that the selected cells contain multiple numeric pairs and that the data is not stored as text.
- The axes appear reversed: Open Select Data and edit the series so the intended horizontal cells are under X values and the intended vertical cells are under Y values.
- Excel treats dates strangely: Dates are stored as serial numbers, so they can serve as scatter-plot X values. Confirm the cells are real Excel dates, and format the axis to display dates in a readable way.
- Points overlap: Several observations may share the same coordinates. Try smaller or transparent markers, or use labels selectively. Overlap does not mean the duplicate records disappeared from the source.
- A category such as a department name is on an axis: A standard XY scatter plot needs numerical X and Y values. For named categories, a line chart with a category axis or another chart type may be more appropriate.
A frequent misconception is that a scatter plot automatically proves that one variable causes another. It only displays the association between the supplied values. Other factors, data quality, and the way observations were collected matter when interpreting the pattern.
Scatter plot versus line chart
Both chart types can show points and lines, but their horizontal axes behave differently. In a scatter chart, the X axis is numerical and spaces observations according to their values. In a line chart, the horizontal axis is generally a sequence of categories, such as month names, with categories spaced evenly. Use a line chart when the main purpose is to compare values across an ordered set of labels and equal spacing is appropriate. Use a scatter chart when the actual distance between X values is meaningful.
For example, monthly sales for January, February, and March often suit a line chart because the months are evenly spaced categories. Measurements taken after 1, 3, and 12 days suit a scatter chart if the longer gap should occupy more horizontal space. Choosing the chart based on the meaning of the X values is more reliable than choosing it just because both options can draw a line.
Frequently Asked Questions
Can I make a scatter plot with more than two columns?
Yes. Use one X column and one Y column for each series, then add each pair through Chart Design > Select Data > Add. If all groups share the same X values, you can reuse that X range and assign a different Y range to each series.
Can the X-axis be dates?
Yes. Excel dates are numeric values internally, so they can be plotted on a scatter chart. Use actual date values rather than text that merely looks like a date, and format the axis to show a suitable date display.
How do I add a trendline?
Select the data series, then choose Chart Design > Add Chart Element > Trendline and select an available type, such as Linear. A trendline summarizes a chosen mathematical relationship; it does not establish causation or guarantee that the pattern will continue.
Why are my points connected?
You may have selected a scatter subtype with straight or smooth lines. Select the chart, open Chart Design > Change Chart Type, and choose the markers-only Scatter option if the observations should not be connected.
Will a scatter chart update when I add rows?
It generally updates when its source is an Excel Table and the new row becomes part of that table. If the chart uses a fixed range or manually specified series ranges, check Select Data and extend the source ranges as necessary.
Related
- Excel Protect Sheet: How to Edit Protected Cells Easily
- Excel Protect Sheet but Allow Grouping: What Works
- Excel: Protect a Sheet but Keep Slicers Usable for Users
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Online Page Break Preview: Limits and WorkaroundsExcel for the web does not include the desktop Excel Page Break Preview view, so you cannot use…
- Excel Power Query: How to Split Text into Separate ColumnsIn Excel for Microsoft 365 on Windows, select the text column in Power Query Editor, then choose Transform…
- Google Docs Employee Schedule Template: Create and Share ItYes. You can make a Google Docs employee schedule template by inserting a table, adding dates and shift…
- Vendor Comparison Matrix Template in Excel: Scoring GuideA vendor comparison matrix template in Excel puts suppliers side by side against the same requirements, costs, and…
- How to Run Apps Script in Google Sheets: A Practical GuideTo run Apps Script in Google Sheets, open your spreadsheet, select Extensions > Apps Script, add and save…
- Excel Unmerge Shortcut: How to Unmerge Cells on WindowsIn Excel for Microsoft 365 on Windows, select a merged cell and press Alt, H, M, U to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.