An Excel XY scatter plot cannot use text categories directly on its x-axis: the horizontal axis is a continuous numeric scale. For categorical labels, use a line chart with markers; if numeric spacing is important, assign each category a number and add the labels separately.
Why a scatter plot needs numeric x-values
A scatter chart places each point using a pair of coordinates: an x-value and a y-value. Excel treats both coordinates as numbers, so it can position a point at a meaningful distance along a continuous scale. That is useful for questions such as whether height is related to weight, or how a measurement changes over time.
Text labels such as North, South, and West do not have numerical distances between them. Excel therefore cannot treat those labels as ordinary scatter-plot x-values. If you enter text in the x-value range, Excel may interpret it as missing data or assign values in a way that does not create a true category axis. A chart that appears to show category names is not necessarily spacing them as categories.
This distinction matters when the gaps between x-values carry meaning. Measurements at 1, 2, and 10 should have a much larger gap between the last two points. By contrast, in a category chart, the labels A, B, and C are usually arranged at equal intervals regardless of their wording.
Choose a chart based on what the x-axis means
If the x-axis represents named groups with no meaningful numerical distance, a category chart is usually the right choice. In Excel, a line chart with markers can display one marker per category and retain a category axis. You can remove the connecting line if you want the points to look more like a scatter chart.
Use an XY scatter chart when x-values are measurements, dates stored as serial numbers, or other quantities where distance matters. If your categories are ordered levels—such as low, medium, and high—you can choose either approach: a category chart preserves their equal spacing, while a scatter chart with codes can show unequal spacing if you deliberately assign it.
- Text groups, equal spacing: use a line chart with markers and no connecting line.
- Numeric measurements or uneven intervals: use an XY scatter chart.
- Categories with individual observations: consider a dot plot or strip plot built from numeric category codes, with labels added as a separate step.
Make a category chart that looks like a scatter plot
For many reports, this is the simplest solution. Put the category names in one column and the corresponding values in another. Select both columns, then choose Insert > Insert Line or Area Chart > Line with Markers in Excel for Microsoft 365 on Windows. Excel uses the first column as category labels and places the observations at equal intervals.
- Arrange the data with one category per row, for example Product A, Product B, and Product C in column A, and the measured values in column B.
- Select the category and value columns, including their headers.
- Choose Insert > Insert Line or Area Chart > Line with Markers.
- If Excel connects the points and you want isolated dots, select the series, open Format Data Series, and set the line to No line. Keep the markers turned on.
- Add or edit axis and chart titles from Chart Design > Add Chart Element.
The result has a categorical horizontal axis and visible markers, but it is not an XY scatter chart. Each category occupies an equal position even if the labels are numeric-looking values such as 2, 5, and 20. That is the desired behavior for categories, but not for measurements where the intervals represent real differences.
When there are several values for each category, arrange each series in its own column and use the category names in the first column. A line chart will place all series at the same category positions. If connecting lines imply a trend that is not present, remove the lines from each series and retain the markers.
Use numeric category codes in a true scatter chart
If you need XY scatter behavior, create a helper column assigning a numeric position to each category. For example, assign 1 to North, 2 to Central, and 3 to South. Use those codes as the x-values and the measured figures as the y-values, then insert a scatter chart with markers. Every observation in the same category receives the same x-code.
This preserves the scatter chart’s numeric coordinate system, but the x-axis initially shows 1, 2, and 3—not the category names. It also treats the differences between the codes as numeric intervals. Equal integer codes make the groups equally spaced, but a code of 10 would be much farther from 2 than 3 is. Choose codes to reflect the spacing you actually want, not simply because they are convenient.
To keep the data understandable, retain a lookup table showing each code and its label. Do not replace category names in the source data with numbers without documenting the mapping. If the category order changes, update the codes consistently; otherwise the chart may silently show a different order than the table suggests.
Ways to show category names on the scatter chart
Excel does not provide a standard text-category axis for an XY scatter chart. The chart’s x-axis labels are numeric values, so assigning codes alone does not turn that axis into a categorical one. There are several workarounds, and each has trade-offs.
- Use a line chart instead: this is the cleanest option when equal category spacing is correct and the labels need to behave like ordinary axis labels.
- Add labels to the plotted points: select the data series, use Chart Design > Add Chart Element > Data Labels, then open More Data Label Options. In supported desktop versions, choose Value From Cells and select cells containing the category labels. Turn off the numeric value label if you do not want it. These labels sit near the points, not automatically along the axis.
- Create a helper series for labels: add one point at each category code with a y-value near the bottom of the plot, and apply labels from cells to that series. Hide its marker and reserve room below the points by adjusting the vertical-axis minimum. The labels can then resemble axis labels, although chart resizing or changed axis limits may require repositioning or adjustment.
Data labels from cells are useful when each point needs its category or name identified. For dense charts, they can overlap and become hard to read. A helper series can put labels in a consistent row, but it is a charting workaround rather than a true category axis. For presentations where reliable alignment and easy editing matter more than retaining XY spacing, a category chart is often more maintainable.
Common problems and how to avoid them
- The x-axis shows 1, 2, 3 instead of names: that is normal for a scatter chart using numeric codes. Use a line chart for native category labels, or add labels from cells as a workaround.
- Excel ignores text x-values: scatter charts require numeric x-coordinates. Keep the names in a separate label column and use numeric coordinates if you must retain the XY chart type.
- Category order looks wrong: category charts generally follow the order of the source rows. Sort the source table into the intended order; do not assume Excel will sort names alphabetically or numerically for you.
- Repeated categories overlap: observations assigned the same x-code sit directly above one another when their y-values are similar. A category chart can show the group pattern, while a dot plot may need small, deliberate horizontal offsets to reveal coincident observations. Those offsets change the displayed x-position, so use them only to separate points visually.
- A line suggests a relationship that is not real: turn off the connecting line or use a different chart type. Lines imply an order or continuity between points that may not exist for unrelated groups.
- Labels collide or disappear: reduce the number of labels, widen the chart, or use a helper series with more space at the bottom. Check the result after resizing and before exporting or printing.
On Excel for Mac, the chart concepts are the same, though ribbon and pane wording can vary slightly by release. Excel for the web may expose fewer chart-formatting controls than the desktop app, so a helper-series label layout is generally easier to build or adjust in desktop Excel.
Scatter plot versus line chart: the practical difference
The common misconception is that a line chart is merely a scatter chart with lines. Both can display markers, but their horizontal axes behave differently. A scatter chart positions points according to numeric x-values and scales the axis continuously. A line chart places points at successive category positions, generally with equal spacing, even when the labels look numeric.
For example, suppose three departments have average response times of 4, 7, and 12 minutes. If the departments are simply groups to compare, a category chart gives each department equal visual space. If the x-values instead represent elapsed minutes and you are plotting a response measured at several time points, a scatter chart communicates the true intervals. Pick the chart based on the meaning of the x-values, not on whether the points look attractive.
Frequently Asked Questions
Can an Excel scatter plot have text on the x-axis?
Not as a native categorical axis. An XY scatter chart needs numeric x-values. Use a line chart for a real category axis, or use numeric codes and add text labels separately.
Can I change a scatter chart into a line chart?
Yes. Select the chart and choose Chart Design > Change Chart Type, then select a line chart with markers. Check the data ranges and axis behavior afterward, because the line chart will treat x-values as category positions rather than continuous numeric coordinates.
Can I use dates as the x-values in a scatter chart?
Yes, if the cells contain valid Excel dates. Excel stores dates as numbers, so a scatter chart can position them according to elapsed time. Text that merely looks like a date may not be recognized as a numeric date value.
How do I show category names beside scatter-plot points?
Add data labels, open More Data Label Options, and use Value From Cells to select the label cells where that option is available. This labels points; it does not create a categorical x-axis.
Why are categories equally spaced in my line chart?
A line chart uses a category axis, so each category gets its own position regardless of numeric-looking label values. Choose an XY scatter chart when the gaps between x-values must represent actual numeric distances.
Related
- Excel Power Query Training: Skills, Courses, and Practice
- Excel Power Query Value Replacement: How to Use It
- Excel Power Query Value Filtering Explained
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Graph Z Scores in ExcelTo graph z scores in Excel, calculate each score’s z value, then plot the results with a histogram…
- Excel Pivot Table Rows Side by Side: Layout, Steps, and TipsTo put PivotTable row fields side by side in Excel for Microsoft 365 on Windows, click inside the…
- Pivot Table in Excel: What It Does and How to Use ItA PivotTable in Excel is an interactive tool for summarizing and exploring data; it is not a worksheet…
- Pivot Chart Examples for Excel: Sales, Trends, and MoreUseful Excel PivotChart examples include monthly sales by region, expenses by department, inventory by product category, and support…
- Data Modeling in Excel Power Pivot: A Practical GuideData modeling in Excel Power Pivot means connecting related tables in one workbook so they can be analyzed…
- Excel Pivot Table Filter Not Refreshing? Fixes That WorkIf an Excel pivot table filter is not refreshing, first select the PivotTable and choose PivotTable Analyze >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.