To make a marked scatter plot in Excel for Microsoft 365 on Windows, select the cells containing your numeric X and Y values, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter with only Markers. Excel plots each row as a point, using the first selected numeric column for the horizontal axis and the next for the vertical axis.
What a marked scatter plot means
A marked scatter plot is an XY chart that displays data points as individual markers. In Excel, its chart type is named Scatter with only Markers. “Marked” refers to the symbols—such as circles, squares, or triangles—that show the observations. The chart does not connect those points with lines.
Each point represents a pair of values: one X value and one Y value. For example, if a worksheet has hours studied in one column and test scores in another, a point at (4, 82) represents four hours and a score of 82. The pattern of points can help reveal association, clusters, unusual values, and possible nonlinear relationships.
This is different from a line chart, which typically treats the horizontal axis as a set of categories and spaces those categories evenly. A scatter chart uses a numeric value axis for both X and Y, so the distance between X values matters. Use a marked scatter plot when you want to compare two quantitative measurements.
Prepare the worksheet data
Arrange the data so that each observation occupies one row and the X and Y measurements occupy separate columns. Include clear headers in the first row. For instance, a table might have Hours in A1, Score in B1, and paired measurements in A2:B21. Each row from 2 through 21 then becomes one plotted point.
- Use numeric values for both axes. Excel stores dates as numbers, so dates can also be used as X values.
- Keep each X value on the same row as the Y value it belongs with. Sorting just one column can break the pairings and produce a misleading chart.
- Keep headers directly above the data and avoid blank rows within the range. Blank cells can create gaps or complicate how Excel interprets a selected range.
- Check for numbers stored as text. Values aligned or behaving differently from other numbers may need conversion before the chart will plot them as expected.
If the columns are not next to one another, you can still add them as a series through the chart’s data-selection controls. For a basic chart, however, adjacent columns with one header row make Excel’s automatic interpretation more dependable.
Create a scatter chart with markers
- Select the two data columns, including their headers. If the columns are adjacent, dragging over the rectangular range is usually simplest.
- On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart.
- Select Scatter with only Markers, the option that shows points without connecting lines.
- Review the result. Check that the horizontal axis represents the intended X measurement and the vertical axis represents Y.
- Add a descriptive chart title and axis titles if the chart will be shared or used in a report.
If Excel assigns the wrong columns, select the chart and open Chart Design > Select Data. In the Select Data Source dialog, select the series and choose Edit. Set the series name to the header cell if appropriate, then set Series X values to the X data cells and Series Y values to the corresponding Y data cells. The two ranges should contain the same number of observations and generally should not include their headers.
In Excel for Mac, the chart is also available from the Insert tab’s Scatter chart options; dialog layout and ribbon arrangement can vary slightly by release. Excel for the web can create and format basic charts, but some detailed formatting controls may differ or be more limited. If a marker option or data-label control is unavailable in the browser, open the workbook in the desktop app.
Choose the right scatter subtype
Excel offers several scatter chart subtypes, and the choice changes how observations are connected—not what the underlying data means.
- Scatter with only Markers: Shows each observation separately. This is the usual choice for comparing measured pairs or exploring a relationship.
- Scatter with Smooth Lines and Markers: Draws a smoothed line through points and keeps the markers visible. The curve is a visual connection, not automatically a statistical model.
- Scatter with Straight Lines and Markers: Connects consecutive observations with straight segments. This can suit ordered sequences, such as a measurement recorded over time, when the order matters.
For example, a chart of engine temperature against vehicle speed may be clearest with markers only if each row is a separate test. If each row is a sequential reading from one run, connecting the points may communicate the sequence. Do not choose a connected subtype merely because it looks polished: lines can suggest continuity or order that the data does not have.
Format marker size, shape, and color
To change the symbols, right-click a plotted point and choose Format Data Series. In the formatting pane, open Fill & Line, expand Marker, and adjust the marker options. Depending on the selected option, you can choose a built-in shape, size, fill, and border. Selecting the series formats its points together; selecting an individual point may let you format that observation separately.
Make markers large enough to see at the chart’s final display size, but not so large that dense points merge into a solid patch. A restrained contrasting fill and border usually works better than a different bright color for every observation. If two groups must be compared, create separate data series and use distinct marker styles or colors for the groups. This also makes a legend useful.
When many observations overlap, try smaller markers, partial transparency if available in the format pane, or a different chart design. Transparency can help reveal dense areas, but very faint points may disappear against a light background. Consider whether the overlap itself is important: a large pile of points may indicate repeated or concentrated values rather than a formatting flaw.
Add titles, labels, and a trendline
A chart title should describe the comparison rather than merely say “Scatter Plot.” Axis titles should include the measured quantity and, where relevant, its unit—for example, Time (minutes) and Distance (kilometers). On the Windows ribbon, select the chart and use Chart Design > Add Chart Element to add a chart title, axis titles, data labels, or a trendline. You can also use the chart elements button beside the chart in supported desktop layouts.
Data labels can identify exact values, but labeling every point in a large dataset often makes the chart unreadable. To label just a few important observations, select a point and add or format a label for that point. In desktop Excel, the Format Data Labels pane can offer Value From Cells, allowing labels to come from a worksheet range—for example, product names paired with X and Y measurements. The cell range should line up with the plotted points. If you only need the coordinates, select X Value and Y Value in the label options where available.
A trendline can summarize a pattern, but it does not prove that one measurement causes the other. Select the chart, then choose Chart Design > Add Chart Element > Trendline and select a suitable type. A linear trendline is useful when a straight-line relationship is a reasonable summary; other choices should be based on the data and the question being asked. Displaying an equation or R-squared value is optional and should not be treated as a substitute for checking the assumptions behind the analysis.
Set useful axis scales
Excel chooses axis bounds and intervals automatically, but the automatic scale is not always the clearest. Right-click an axis and choose Format Axis to set bounds, units, number formats, or other available axis options. A sensible scale can make clusters and differences easier to interpret. If the chart compares measurements with meaningful zero points, consider whether starting an axis above zero could exaggerate visual differences.
Scatter charts use numeric scales on both axes. If X values are irregularly spaced, Excel places them according to their numerical distance; a value of 20 is twice as far from 10 as 15 is. That behavior is a key reason to use a scatter chart rather than a line chart for numeric X data. If the labels are categories such as department names, a line chart or another chart type may fit the task better.
Fix common scatter plot problems
- Points appear in the wrong direction: Open Chart Design > Select Data and edit the series’ X and Y ranges. Excel may have interpreted the columns in the opposite order.
- Only one point appears: Check that the selected ranges contain all observations and that X and Y ranges have matching lengths. Also confirm that most values are numeric rather than text.
- The chart has unexpected gaps: Look for blank cells, text entries, or formula results that return empty text. Review how the chart handles empty cells if gaps need special treatment.
- Points overlap heavily: Reduce marker size, use separate series for groups, or examine a smaller relevant range. Overlap can hide the number of observations at a location.
- The horizontal axis shows 1, 2, 3 instead of the X measurements: Excel may not have assigned the intended X-value range. Edit the series and set Series X values explicitly.
- The relationship looks misleading: Check both axis scales, confirm the row pairings, and consider whether a trendline or connected points are implying more than the data supports.
Scatter plots compared with line charts
The most important distinction is the horizontal axis. A scatter chart positions points using actual numeric X values and preserves the intervals between them. A line chart generally places categories at evenly spaced positions, even if the category labels look numeric. For example, measurements taken after 1, 2, and 10 hours should not have equal horizontal spacing if elapsed time is the true X variable; a scatter chart represents those intervals more faithfully.
Choose a line chart when the horizontal axis is an ordered set of categories or dates and the focus is on a series changing across that sequence. Choose a marked scatter chart when both variables are quantitative and their paired values are the subject. In some time-series situations, either chart can be reasonable: use a scatter chart when actual time gaps matter, and a line chart when regularly spaced periods are being treated as successive categories.
Frequently Asked Questions
What is the Excel chart type for a marked scatter plot?
Choose Scatter with only Markers from Insert > Insert Scatter (X, Y) or Bubble Chart. It shows data points without joining them with lines.
How do I add markers to an existing scatter chart?
Select the chart, open Chart Design > Change Chart Type, and choose Scatter with only Markers. If you want to keep lines, select a scatter subtype that includes both lines and markers instead.
Can a scatter plot use dates on the X-axis?
Yes. Excel stores dates as serial numbers and can plot them as numeric X values. Format the horizontal axis as dates if it displays serial numbers, and check that the series uses the date cells as its X values.
Why does Excel show the wrong values on the X-axis?
The X range may not be assigned to the series, or Excel may have guessed the data layout incorrectly. Use Chart Design > Select Data > Edit and specify the X and Y ranges separately.
Can I label scatter plot points with names?
Yes. In desktop Excel, add data labels and use Value From Cells in the Format Data Labels pane when that option is available. Choose a worksheet range containing one label for each plotted point.
Related
- Corrupted Excel File: How to Repair and Recover It
- How to Split a Cell in Excel: Text, Columns, and More
- How to Run Scenario Manager in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Flash Fill in Excel: Fill Blanks or Detect PatternsFlash Fill in Excel recognizes a pattern in your examples and fills an adjacent column with matching results;…
- Heat Map in Excel: How to Create OneTo create a heat map in Excel for Microsoft 365 on Windows, select the numeric cells you want…
- Excel Not Responding and Not in Task ManagerIf Excel says Not Responding but you cannot find it in Task Manager, first check the Processes and…
- Excel Frequently Not Responding? Causes and FixesIf Excel frequently shows “Not Responding,” first give it a short time to finish, especially if it is…
- How to Delete Gridlines in Excel for a Cleaner SheetTo hide gridlines in Excel for Microsoft 365 on Windows, open the worksheet, select the View tab, and…
- Google Sheets Function to Count Cells Containing TextIn Google Sheets, use =COUNTIF(A2:A20,"*") to count cells containing text in the range A2:A20. The asterisk is a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.