Excel Scatter Plot X-Axis Text: How to Add Labels

Charts & pivot tables · Updated November 21, 2026

In Excel, a scatter plot’s x-axis must use numeric values, so it cannot use text categories as ordinary axis positions. To show text, use a line chart for category labels, or keep the scatter plot and add text as data labels from cells; add an axis title separately if you only mean the name of the x-axis.

What “X-axis text” can mean

The phrase “x-axis text” can refer to two different things: the axis title, such as Distance (km), or the tick labels that appear along the axis, such as 0, 5, 10, and 15. It can also mean names attached to individual points, such as product names or city names. These are controlled in different ways in Excel.

  • Axis title: A descriptive label for the whole horizontal axis.
  • Tick labels: The values that mark positions along the axis.
  • Point labels: Text identifying individual observations in the chart.

Knowing which one you need prevents a common detour: changing the axis title will not replace the numeric tick labels, and adding point labels will not create a true text-based axis.

Why a scatter plot needs numeric x-values

An XY scatter chart positions each point according to a pair of numbers: one x-value and one y-value. The distance between x-values matters. For example, a point at x = 20 is twice as far from zero as a point at x = 10, and the chart preserves that spacing. This makes scatter plots useful for measurements, scientific data, dates stored as numbers, and any relationship where the horizontal position has quantitative meaning.

Text categories such as North, South, East, and West do not specify numeric distances. Excel therefore cannot place them as normal scatter-plot coordinates in the same way it places 10 and 20. If a worksheet column contains text where Excel expects numeric x-values, the chart may omit or misinterpret those entries. Convert data that represents numbers but is stored as text into real numbers before charting.

This is not simply a formatting limitation. Replacing numeric positions with category names would change what the chart communicates. If the categories are equally spaced groups rather than measured values, a chart with a category axis is usually the clearer choice.

Add or change the x-axis title

If you want a descriptive phrase beneath the horizontal axis, add an axis title. In Excel for Microsoft 365 on Windows:

  1. Select the chart.
  2. Choose Chart Design > Add Chart Element > Axis Titles > Primary Horizontal.
  3. Click the title box that appears beneath the chart and type a useful description, such as Month, Temperature (°C), or Advertising Spend ($).

The title describes what the scale measures; it does not change the scale or its tick labels. Include units when they help readers interpret the values. For example, Sales is less specific than Sales (units), and Distance is less informative than Distance (km).

If the title option is unavailable or the result looks different, confirm that the chart is selected and that it is a chart type with a horizontal axis. Excel for Mac also provides chart-element controls, though the ribbon layout can differ slightly. In Excel for the web, chart editing options may be more limited than in the desktop application.

Show text beside scatter-plot points

When each dot represents a named item, cell-based data labels are usually the most practical solution. The scatter plot retains its numeric x-values, while labels such as Site A or Trial 1 identify the points. In Excel for Microsoft 365 on Windows, arrange the worksheet with numeric x-values in one column, numeric y-values in another, and the desired names in a third. Create the scatter chart using the x- and y-value columns, then:

  1. Select a point in the chart to select its data series.
  2. Choose Chart Design > Add Chart Element > Data Labels and add labels. The initial label choice is not important because you can change its contents next.
  3. Right-click a label and choose Format Data Labels.
  4. In the Format Data Labels pane, under Label Options, select Value From Cells, then choose the cells containing the names.
  5. Clear options such as X Value or Y Value if you want names only, and choose a label position that does not cover the points.

For example, a worksheet might contain elapsed time in column A, measured speed in column B, and test names in column C. Plot A against B, then use C for the labels. The dots remain at their measured coordinates, but readers can identify each test without a separate legend. If labels collide, shorten the names, enlarge the chart, or label only the points that need explanation.

These are data labels, not axis tick labels. They stay associated with observations and generally move with their points when the chart changes. Excel for Mac has chart-label controls as well, but the pane layout and exact availability of Value From Cells can vary by release. If the option is missing, update or use the desktop version, or use a helper series as described below.

Put category names along the bottom

If your intended x-axis is a list of categories rather than a measured scale, a line chart is often the simplest answer. Put category names in one column and the corresponding values in another, select the range, and insert a line chart. The category names appear along the horizontal axis. A line chart treats the categories as positions in an ordered sequence; it does not calculate numeric spacing between their names.

That difference matters. Suppose measurements were taken after 1, 2, and 10 days. A scatter chart can show the long interval between days 2 and 10. A line chart using those dates as categories may space the three observations evenly, depending on its axis settings, which can suggest a misleading rhythm. Conversely, if the x-values are product types A, B, and C and the spacing has no quantitative meaning, equal category spacing may be exactly right.

If you must keep a scatter chart but want category names visually near the bottom, use a helper series. Give each category a numeric x-position, create a second series with those same x-values and y-values near the lower edge of the plot, then add labels from the category-name cells to that series. Format the helper series with no visible line or marker, leaving its labels visible. This approach takes more setup and the labels are still data labels rather than native axis ticks. Adjust the vertical axis bounds carefully so the helper labels have room and do not overlap real data.

When to use a line chart instead

Choose the chart based on what horizontal position means, not merely on whether the source cells contain text. A scatter chart is appropriate when x-values are numbers and their spacing carries information: height versus weight, time versus temperature, or price versus demand. A line chart is usually more suitable when the x-axis represents named groups or an ordered sequence whose entries should be evenly spaced.

There are exceptions. Dates and times are numeric values in Excel, so a scatter plot can represent elapsed intervals proportionally. If you want to display dates in a scatter plot, use real Excel dates as the x-values and format the axis to display dates. That changes how numeric dates look; it does not make arbitrary text categories into numeric positions.

A useful check is to ask whether the gap from the first x-item to the second should be the same visual width as the gap from the second to the third. If yes, a category-based chart may fit. If the actual differences between x-values should control the spacing, use a scatter chart and retain its numeric scale.

Fix common x-axis label problems

  • The x-axis shows 1, 2, 3 instead of my names. The chart may be using numeric positions. For category names, switch to a line chart; for named observations, use data labels from cells.
  • The points appear in the wrong places. Check the series’ X and Y ranges. Right-click the chart and choose Select Data, select the series, and choose Edit to review its X values and Y values. Make sure each range contains the intended numeric cells and that the rows correspond.
  • Some points disappear. Check for blank cells, text-formatted numbers, or errors in the x- or y-value ranges. Convert numeric-looking text to numbers and verify the chart series includes the full data range.
  • The labels overlap. Try a different data-label position, reduce the number of labels, or widen the chart. Long labels rarely fit well beside tightly clustered points.
  • The scale starts or ends at an unexpected value. Right-click the horizontal axis and choose Format Axis. Under Axis Options, review the minimum and maximum bounds and the major unit. Automatic bounds can change when the data changes.

When adding a scatter chart from a worksheet, it is often easiest to select the numeric x- and y-value columns first. If the columns are not adjacent, select one range and then use Ctrl while selecting the other on Windows. You can also create the chart and assign the ranges through Select Data. Keep category-name cells separate from the numeric coordinate ranges unless you are using them specifically for data labels.

Make labels readable and honest

Text can clarify a chart, but too much of it can obscure the data. Label only important points when the chart contains many observations; a label on every dot can become a dense block of overlapping words. Use a legend when colors represent groups, and use point labels when readers need to identify specific observations. If both are necessary, keep the naming scheme consistent and explain abbreviations.

Also avoid implying that category codes are measured quantities. Mapping labels such as Bronze, Silver, and Gold to 1, 2, and 3 can make a scatter plot possible, but the numeric gaps may imply a scale that does not exist. If you use numeric positions only as convenient placeholders, make that clear and consider whether a category-axis chart would communicate the data more accurately.

Frequently Asked Questions

Can an Excel scatter plot have text on its x-axis?
A scatter plot uses numeric x-coordinates, so arbitrary text cannot serve as its native scale. Use a line chart for category tick labels, or show text as data labels beside scatter points.

How do I add an x-axis title in Excel?
Select the chart and choose Chart Design > Add Chart Element > Axis Titles > Primary Horizontal. Click the title box and enter the description and units.

How do I show names next to points in a scatter plot?
Add data labels, open Format Data Labels, select Value From Cells, and choose the worksheet cells containing the names. Clear the numeric label options if you want names alone.

Can I replace 1, 2, and 3 with custom words on a scatter axis?
Not as ordinary scatter-axis tick labels using a direct text range. Use a category chart, data labels, or a carefully positioned helper series if the scatter chart is essential.

Should I use a line chart or a scatter chart for dates?
Use a scatter chart when the actual time gaps matter and your dates are valid Excel date values. Use a line chart when you want observations treated as equally spaced categories or sequence entries.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.