In Excel for Microsoft 365 on Windows, change a scatter plot’s horizontal values by selecting the chart, choosing Chart Design > Select Data, selecting a series, and clicking Edit under Legend Entries (Series); then edit Series X values. A scatter plot uses a numeric x-axis, so its tick labels come from the values and scale—not from a separate list of category names.
What x-axis labels mean on a scatter plot
People use “x-axis labels” to mean two different things in Excel. They may mean the numbers printed along the horizontal axis, such as 0, 5, 10, and 15. Or they may mean names for individual points, such as “North,” “South,” and “West.” Those are different chart elements, and the distinction explains many apparent labeling problems.
In an XY (scatter) chart, each point is positioned using a pair of numeric values: one x value and one y value. Excel reads the x values from the series’ Series X values range, then draws a numeric scale across the axis. It chooses suitable tick marks and labels based on the data range and chart size. You can adjust that scale, but you do not normally type a custom list of category labels into the axis settings.
This differs from a line chart, which commonly treats the horizontal axis as categories. A line chart can display labels such as months or product names at evenly spaced category positions, even when the categories are text. A scatter chart instead places points according to their actual numeric x values; the distance between 2 and 4 is the same as the distance between 8 and 10.
Change the series’ x-value range
If the plotted points are in the wrong horizontal positions, or the axis shows values you did not expect, check the series range first. For example, suppose column A contains time in minutes and column B contains distance. The x range should refer to the time values in column A, while the y range should refer to distance in column B. If those ranges are reversed or include a heading or unrelated cells, the chart will not represent the intended relationship.
- Select the scatter chart. If needed, click a point in the series you want to adjust.
- On the ribbon, choose Chart Design > Select Data.
- In the Select Data Source window, select the relevant series under Legend Entries (Series), then choose Edit.
- In the Edit Series window, set Series X values to the cells containing the horizontal measurements. Set Series Y values to the matching vertical measurements.
- Choose OK to close the dialogs and inspect the chart.
The x and y ranges should normally contain the same number of data cells, with each x value paired with the y value on the same row. For example, if time measurements are in A2:A7 and distances are in B2:B7, use those corresponding ranges. Do not include the column headings in one range but not the other. If the data is in an Excel table, adding rows to the table can help keep the chart’s source data current as the table grows.
To add another group of points, use Chart Design > Select Data > Add, then specify the new series name and its x and y ranges. Each series has its own x-value range; scatter charts do not require every series to use identical x values.
Adjust the numeric axis and its tick labels
To change where the axis starts or ends, or how often its numbers appear, right-click the horizontal axis and select Format Axis. In the Format Axis pane, open Axis Options. Depending on the chart and the available settings, you can set numeric bounds and major or minor units. For example, if measurements run from about 12 to 38, setting a minimum of 10 and a maximum of 40 can make the displayed scale easier to read. These settings change the visible scale, not the underlying x values or the positions those values represent.
Excel usually chooses bounds and tick spacing automatically. That is useful for a quick chart, but the automatic scale may change when you add data or resize the chart. Set bounds manually when a consistent scale is important for comparing charts or when the automatic scale makes a modest difference look larger than it is. Avoid cutting off meaningful data: a fixed minimum or maximum can hide points outside the displayed range.
For the number format, select the axis and open Format Axis. Expand Number to choose a format or enter a suitable format code. This controls how the tick values appear, not the underlying values. For example, formatting a value of 0.25 as a percentage can display it as 25%, while its numeric value remains 0.25. If you change the format but see no difference, check that the format is appropriate for the scale and that the source values are numbers rather than text.
You can also change the axis title separately from the tick labels. Select the chart, then choose Chart Design > Add Chart Element > Axis Titles > Primary Horizontal. Click the title box and enter a description such as “Time (minutes).” An axis title explains what the scale measures; it does not replace the numeric tick labels.
Display dates on a scatter chart
A date can be used as an x value in a scatter chart because Excel stores dates as numeric serial values. If valid dates are plotted, the points can be spaced according to the elapsed time between them. For instance, points dated January 1 and January 3 should be farther apart than points dated January 1 and January 2. This is useful when the intervals between observations are meaningful and not always equal.
If the axis displays numbers instead of dates, select the horizontal axis, open Format Axis, and adjust the number format to a date format. Also confirm that the source cells contain actual Excel dates, not text that merely looks like a date. A cell’s appearance does not prove that Excel recognizes its contents as a numeric date. If dates are text, convert them to real dates before relying on their positions in a scatter chart.
Choose a line chart instead if the goal is to show a sequence of labeled dates at equal category spacing, regardless of the gaps between dates. The right chart type depends on whether horizontal distance should represent the actual numeric or time interval.
Show custom names beside individual points
If you want names such as “Trial A” or “Station 4” next to plotted points, add data labels rather than trying to replace the scatter chart’s numeric axis labels. Select the series, choose Chart Design > Add Chart Element > Data Labels, and select a label position. Then right-click one of the labels and choose Format Data Labels. In the Format Data Labels pane, under Label Options, select Value From Cells and choose the cells containing the names. Clear options such as X Value or Y Value if you want names without the numeric coordinates.
Keep the label range in the same order as the points in the series. If the first plotted point corresponds to row 2, the first label should also come from row 2. Labels can overlap when points are close together, so use short names, move labels where possible, or label only the points readers need to identify. Data labels describe points; they do not turn the x-axis into a text-based category axis.
For a chart that needs names along the horizontal axis and does not need numeric spacing, consider a line chart or another category chart instead. A common misconception is that changing the axis label range in a scatter chart will make it behave like a category chart. Scatter charts are designed to map numeric x and y coordinates, so changing the data label range is not the same as changing the axis model.
Choose between a scatter chart and a line chart
Use a scatter chart when both variables are numeric and the horizontal position has quantitative meaning: for example, hours studied versus test score, temperature versus energy use, or elapsed time versus distance. Unequal x intervals remain unequal on the chart, which helps reveal relationships such as clusters, gaps, or trends.
Use a line chart when the horizontal values represent an ordered set of categories, such as departments, stages, or monthly reporting periods that should appear at regular intervals. A line chart is also often a clearer choice when the purpose is to show a trend across a familiar sequence rather than the exact spacing between observations. You can include date labels on a line chart as categories; in a scatter chart, date values determine actual positions.
If you are unsure, ask what the horizontal distance is meant to communicate. If moving from 2 to 4 should cover the same distance as moving from 8 to 10, a scatter chart is appropriate. If each item should take one equal step regardless of its numeric value or time gap, a category chart is usually a better fit.
Common x-axis labeling problems
- The axis shows 1, 2, 3 instead of the measurement values: Check the series’ Series X values range in Select Data. Excel may be plotting a different column than intended.
- Names do not appear along the axis: That is expected for a scatter chart. Use data labels with Value From Cells to name points, or choose a category chart if text categories belong on the axis.
- Only one point appears: Check that the x and y ranges contain multiple numeric cells and that the ranges align. Text, blanks, or mismatched ranges can prevent the intended points from appearing.
- Dates appear as serial numbers: Confirm that the source cells are genuine dates, then apply a date number format to the horizontal axis.
- Some points seem missing: Check whether fixed axis bounds exclude them. Also inspect the source ranges for blanks or nonnumeric entries.
- Labels collide: Reduce the number of displayed decimals or choose a wider chart, fewer major tick marks, or shorter data labels. Axis labels and point labels can be adjusted independently.
Excel for Mac has the same basic scatter-chart concepts, though ribbon and dialog layouts can vary slightly by release. In Excel for the web, chart editing is available, but some advanced formatting controls may differ from the Windows desktop app. If you cannot find a series-range or axis-formatting control in the browser, open the workbook in the desktop app and use the paths above.
Frequently Asked Questions
How do I change the x-axis labels in an Excel scatter plot?
To change the plotted horizontal values, select the chart and choose Chart Design > Select Data. Select the series, click Edit, and change Series X values. To change the numbers displayed along the axis, use Format Axis to adjust bounds, units, or number formatting.
Can I use text labels on a scatter plot’s x-axis?
Not as ordinary category labels. A scatter chart’s horizontal axis is numeric. To show text for each observation, add data labels and use Value From Cells. If the text categories should occupy equal positions along the axis, use a category chart such as a line chart instead.
How do I make Excel show dates instead of numbers?
Make sure the x-value cells contain real Excel dates, then select the horizontal axis, open Format Axis, and choose a date format under Number. The values remain numeric internally; the format changes how the axis displays them.
Why does my scatter plot start at 0?
Excel may have selected zero as the automatic minimum, or the axis may have a fixed minimum of 0. Right-click the axis, choose Format Axis, and review Bounds under Axis Options. Use an appropriate minimum for the data, while ensuring that no relevant points are excluded.
Can I show the x value next to every point?
Yes. Add data labels to the series and enable X Value in the Format Data Labels pane. You can also use Value From Cells for custom names, or combine label options if the chart needs both a name and a coordinate.
Related
- Excel Protect Sheet: How to Change a Password
- Excel Protect Sheet: How to Edit Protected Cells Easily
- Excel Protect Sheet but Allow Grouping: What Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Stacked Column Chart: Set and Fix the X-AxisIn an Excel stacked column chart, the x-axis is the horizontal category axis along the bottom: it shows…
- How to Insert an Excel Chart in CanvaTo insert an Excel chart in Canva, save the chart from Excel as a PNG image, then upload…
- Butter Bars in Excel: Create a Butterfly ChartTo format butter bars in Excel, create a mirrored bar chart: plot one group’s values as negatives and…
- Box Plot in Excel: Create, Format, and Read the ChartYes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic…
- Excel Pivot Table Totals at Top? Show SubtotalsYes. To put category subtotals above their detail rows in Excel for Microsoft 365 on Windows, click inside…
- Creating a Waterfall Chart in Excel: A Step-by-Step GuideTo create a waterfall chart in Excel for Microsoft 365 on Windows, put each step of the change…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.