If an Excel scatter plot is showing the wrong X axis, select the chart and check the series’ Series X values range under Chart Design > Select Data > Edit. Make sure that range contains the intended numeric x-values, matches the length of the Y values range, and isn’t made up of numbers or dates stored as text.
Start with the chart’s data series
The most common cause is a series linked to the wrong cells. A scatter plot doesn’t use a separate list of category labels for its horizontal axis: each point’s horizontal position comes from that series’ X values. If Excel picked the wrong column, the axis may show row numbers, values from another field, or a range that doesn’t fit the data you meant to plot.
- Click the chart, then open Chart Design > Select Data on the Windows ribbon.
- In the Select Data Source dialog, choose the series under Legend Entries (Series) and click Edit.
- Inspect Series X values and Series Y values. Select the intended data cells for each, excluding the header row.
- Click OK in the Edit Series dialog, then click OK again. Check whether the plotted points now line up with the intended x-values.
For example, if column A contains distance and column B contains time, set A2:A10 as the X values and B2:B10 as the Y values to plot time against distance. If the series instead uses row numbers or a different column for X, the chart can still look plausible while answering the wrong question. Selecting the series and checking its ranges is more reliable than judging the axis labels alone.
On Excel for Mac, select the chart and use Chart Design > Select Data to inspect the series; dialog labels and layout can vary slightly by release. Excel for the web has fewer chart-editing options than the desktop app, so if you can’t edit the series ranges there, open the workbook in desktop Excel.
Why a scatter plot uses X values differently
An XY scatter chart treats both axes as numerical scales. Each row in a series supplies a paired coordinate: one value for X and one for Y. Excel positions the marker according to those coordinates, so the spacing between x-values matters. Points at 1, 2, and 10 are not evenly spaced just because they are three observations.
This differs from a line chart, which commonly places categories—such as month names or labels—at evenly spaced positions along its horizontal axis. A line chart can show the text labels “January,” “February,” and “March” as categories; a scatter chart needs usable numerical x-values. This distinction explains why switching chart types can appear to fix an axis: it changes how Excel interprets the horizontal data, not necessarily whether the underlying source range is correct.
Use a scatter chart when the horizontal values represent measurable quantities, such as height, elapsed time, temperature, or price, and the distance between those values has meaning. Use a line chart when you primarily want to show a sequence of categories or regularly ordered periods. Choosing the right chart type is part of correcting the axis, not just changing its appearance.
Check the selected columns and series layout
When creating a chart from a rectangular selection, Excel guesses which columns are series names and which contain X and Y values. That guess may be wrong, especially if the data has several numeric columns, blank cells, or headings that are not directly above the values. A chart created from only one column of numbers may also use a default sequence for X rather than the real x-values you intended.
For a simple one-series example, keep the independent variable in one column and the measurement in another, with headers in row 1 and matching observations in rows 2 through 6:
- Column A: elapsed time, such as 0, 2, 5, 9, and 14.
- Column B: measured distance, with one value for each time.
After inserting a scatter chart, verify that the X range points to the time cells and the Y range points to the distance cells. If the chart has multiple series, edit each one separately. Each series has its own X and Y ranges, so correcting one series does not automatically correct the others. To add a series, use Chart Design > Select Data > Add, then specify its name and the two value ranges.
Make sure both ranges contain the same number of observations and start and end on corresponding rows. If the X range is A2:A10 but the Y range is B3:B11, Excel pairs values by position, not by matching labels elsewhere in the sheet. That one-row offset can produce a believable but incorrect plot. Headers should be used as the series name, not included among the numeric coordinates.
Make sure the X values are real numbers
A cell can look numeric without being stored as a number. Values imported from a website or text file may contain leading apostrophes, spaces, nonbreaking spaces, or other characters. Text values can prevent Excel from plotting the expected positions or can be treated as missing, depending on the data and chart setup. Check a suspicious cell by selecting it and looking at the formula bar and alignment; formatting alone is not proof that the underlying value is numeric.
Try a small diagnostic before changing the whole dataset: select one suspect cell and change its number format to General. If it remains text, use a careful conversion method, such as selecting the affected cells and choosing Data > Text to Columns > Finish when the values are straightforward numbers. Alternatively, use the warning icon’s conversion option if Excel displays one. Review the results, particularly if the data uses decimal commas, thousands separators, or units embedded in the cells. A value like “12 km” is text until the unit is removed or separated into another column.
Also inspect blanks, error values, and formulas returning an empty string. These aren’t valid numeric coordinates. In a scatter chart, use Chart Design > Select Data > Hidden and Empty Cells to review how empty cells are displayed. That setting can affect gaps or connections, but it does not repair an incorrect X values range or turn text into numbers.
Review axis bounds, direction, and number format
Sometimes the series is correct and the axis only looks wrong because its display settings hide or distort the expected range. Right-click the horizontal axis and choose Format Axis. In the Format Axis pane, review the minimum and maximum bounds, major units, number format, and whether the axis is set to display values in reverse order. Excel usually adjusts bounds automatically, but manually entered bounds can exclude points or make them bunch together near one end.
For instance, if your X values run from 0 to 100 but the axis minimum is fixed at 40, the first part of the scale is hidden. If the maximum is set too low, later points may fall outside the visible plot area. Set the bounds back to Auto to let Excel determine a suitable range, or enter deliberate limits that include the data you want to show. If the axis is reversed, changing that option restores the usual left-to-right order.
Number formatting can create a different kind of confusion. Values may be plotted correctly but displayed as dates, percentages, currency, or rounded numbers. In Format Axis, inspect Number and choose a format that makes the scale understandable. Changing the format alters the labels readers see, not the underlying X values. A logarithmic scale is another special case: it spaces values according to their logarithms and cannot represent zero or negative values. Turn it off if the transformed spacing is not intended.
When the X values are dates or times
Excel stores valid dates as serial numbers, so dates can be used as X values in an XY scatter chart. The markers are positioned according to the underlying date values; formatting the horizontal axis as dates changes the labels, not the positions. If dates appear as unexplained large numbers, right-click the axis, choose Format Axis, and select an appropriate date format under Number.
If dates are text—perhaps imported in a format Excel does not recognize—the chart may not place them as expected. Check whether the cells behave like dates when you change their format or use them in date calculations. Regional settings matter: a string such as 03/04/2025 can mean different dates in different locales. Convert it using the correct interpretation rather than assuming Excel will infer the intended month and day.
For times, confirm that the cells contain actual Excel time values and choose a useful format such as hours and minutes. Time-only values represent fractions of a day, so a chart spanning midnight or multiple dates may need full date-and-time values to preserve chronological order. If you need equally spaced monthly categories rather than spacing based on the number of days between dates, a line chart may better fit the purpose.
Distinguish an axis problem from a chart-type problem
If the horizontal axis shows labels such as 1, 2, 3 instead of your intended values, first check the series X range. If the plotted observations are correctly spaced by numbers but you wanted text categories, you may have chosen the wrong chart type. Select the chart and use Chart Design > Change Chart Type to compare the scatter and line options. Changing the type can alter how Excel reads the same source data, so recheck the series after switching.
Another common misconception is that the axis title controls the data. An axis title is just descriptive text; changing it from “Series 1” to “Time” will not change the X values or move any points. Add or edit an axis title only after the series is configured correctly. Likewise, changing the chart’s overall source selection in the worksheet does not guarantee that each series has the correct X and Y ranges.
A quick troubleshooting order
Work through the checks in this order so you don’t spend time formatting an axis when the data mapping is the real issue:
- Confirm the chart is an XY scatter chart if both variables should be numerical.
- Open Select Data and verify the X and Y ranges for every series.
- Check that each pair of ranges has the same number of rows and aligns observation by observation.
- Confirm the X cells are genuine numbers or dates, not text, errors, or values with unwanted units.
- Set axis bounds to Auto temporarily, check whether the axis is reversed, and inspect its number format.
- Only then adjust labels, titles, gridlines, or other presentation settings.
If the chart still seems wrong, compare a few individual points against their worksheet rows. For a row with X = 5 and Y = 12, the marker should be positioned at (5, 12). This simple check can reveal a shifted range, a mistaken column, or an unexpected value much faster than repeatedly changing chart styles.
Frequently Asked Questions
Why does my Excel scatter plot show 1, 2, 3 on the X axis?
Excel may be using point order or an automatically generated sequence because the series does not have the intended X range. Open Chart Design > Select Data > Edit and assign the cells containing your actual x-values to Series X values.
How do I change the X-axis values in an Excel scatter chart?
Select the chart, choose Chart Design > Select Data, select the series, and click Edit. Replace the Series X values range with the correct cells, then confirm the dialog. Repeat for other series if necessary.
Why are my scatter plot dates showing as numbers?
Excel plots dates using their underlying serial values. The data may be correct even when the labels look like numbers; choose a date format in the horizontal axis’s Format Axis > Number settings. If the cells are text rather than true dates, convert them first.
Why is my X axis in the wrong order?
Check whether Values in reverse order is enabled in the Format Axis pane. Also check that the X values themselves are in the order you expect. A scatter chart positions points by their numerical values, not by their row order.
Should I use a scatter plot or a line chart for dates?
Use a scatter plot when the actual spacing between dates matters, such as when observations are irregularly timed. Use a line chart when dates are categories in a sequence and you want evenly spaced positions. The better choice depends on whether elapsed time or category order is the point of the chart.
Related
- Excel Protect Sheet: How to Select Unlocked Cells Only
- Excel Protect Sheet Greyed Out? Causes and Fixes
- Excel Protected Sheet: Can a Table Still Grow?
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Build a Treemap Chart in Excel Step by StepTo build a treemap chart in Excel, arrange your categories in one or more columns and their numeric…
- Excel Pivot Chart Slicers: How to Add and Use ThemAn Excel PivotChart slicer is a set of clickable filter buttons for a PivotTable and its connected PivotChart.…
- Excel Pivot Table Layout: Rows, Columns, Values & FiltersAn Excel PivotTable layout is the arrangement of fields in four areas—Rows, Columns, Values, and Filters—that determines how…
- Conditional Formatting Bar Chart in Excel: How It WorksTo make a bar chart inside Excel cells, select the values, then choose Home > Conditional Formatting >…
- Reverse Waterfall Chart in Excel: How to Make OneTo make a reverse waterfall chart in Excel for Microsoft 365 on Windows, enter the starting total and…
- Google Sheets Chart Trendlines: Add and Interpret OneTo add a trendline in Google Sheets, open the chart editor, choose Customize > Series, select the data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.