Excel Scatter Plot With Dates on the X-Axis: Setup Tips

To make an Excel scatter plot with dates on the x-axis, put genuine Excel dates in one column and numeric y-values in another, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart. If the horizontal axis shows numbers instead of dates, format that axis with a date number format; a scatter chart still uses the actual date values to position each point in time.

Why dates work in a scatter chart

Excel stores real dates as serial numbers, so a date can be used as the x-coordinate in an XY scatter chart. The serial number represents a position in time; the cell’s number format controls whether you see a date such as 15-Jan-2026 or the underlying number. A scatter chart plots that numeric position, which is why dates can be used without converting them into text labels.

This also means the distance between points reflects the elapsed time. If measurements were taken on Monday and Tuesday, those points are one day apart. If the next measurement was taken a week later, there is a larger gap. That is useful for time-series data with irregular sampling, such as equipment readings, daily sales with missing days, or measurements collected at uneven intervals.

Excel charts can also show dates on a line chart, but the horizontal axis behaves differently. A line chart often treats its horizontal labels as categories, placing each observation at the next category position. A scatter chart uses a numeric value axis, so it preserves the real spacing between dates. Choose scatter when elapsed time or uneven intervals matter.

Prepare the date and value columns

Set up the source data with one date per row and the measurement to plot beside it. For example, column A could contain dates from 1-Jan-2026 onward, while column B contains the corresponding daily temperature readings. Add descriptive headers such as Date and Temperature in the first row. Keep each date paired with its measurement on the same row.

Before charting, check that the dates are values Excel recognizes, not text that merely looks like a date. A date entered into a cell and displayed with a date format is usually usable. Imported data can be different: a value such as 2026-01-15 may arrive as text depending on its source, settings, or import process. If Excel treats it as text, the scatter chart cannot use it as a numeric x-coordinate in the intended way.

Use a consistent date style in the source column, and avoid mixing dates with notes such as unknown or pending.
Make sure the y-values are numeric. Text values, blank cells, or error values may be omitted or plotted unexpectedly.
Sort by date if you want the connecting line to progress chronologically. Sorting is especially important when the chart uses lines between points.
Check for duplicate dates. They are allowed, but observations on the same date share an x-position and may overlap.

For a quick visual check, select a date cell and look at its number format in Home > Number. Changing a cell to General may reveal a serial number if it is a real date. Restore a suitable date format afterward. This check is a clue, not a complete test: imported text can sometimes be converted using Excel’s data tools or by correcting the import settings.

Create the scatter chart

In Excel for Microsoft 365 on Windows, select the date and value columns, including their headers, then use Insert > Insert Scatter (X, Y) or Bubble Chart. Choose the first scatter option for points only, or select a scatter option with straight or smooth lines if connecting observations is appropriate. Excel generally assigns the first selected numeric column as x-values and the next as y-values, but verify the result if the selected range is not a simple two-column block.

Select the Date and measurement data, including headers. If the columns are separated, select the first range, then hold Ctrl while selecting the second range on Windows.
Open the Insert tab, choose Insert Scatter (X, Y) or Bubble Chart, and pick the chart style.
Check that the horizontal positions correspond to the dates and that the vertical positions correspond to the measurements.
If needed, add axis titles from Chart Design > Add Chart Element > Axis Titles. Label the horizontal axis Date and the vertical axis with the measurement and its unit.

On Mac, the chart is also available from the Insert tab, though button layout and wording can vary by Excel release. Excel for the web supports creating and editing many chart types, but its chart-formatting controls may be more limited or arranged differently from the Windows desktop app. If a particular axis option is unavailable in the web interface, open the workbook in desktop Excel.

Format the horizontal axis as dates

If the chart’s horizontal axis displays serial numbers, format the axis labels rather than changing the source data. Right-click the horizontal axis and choose Format Axis. In the Format Axis pane, open Number, choose a date format, or enter a custom format such as dd-mmm-yyyy. If the axis is linked to the source formatting, clear Linked to source when necessary so the chart can use its own display format.

Formatting changes how the values are displayed; it does not change the underlying x-coordinates. A compact format such as mmm-yy may be easier to read over a long period, while dd-mmm can work for a shorter range. Choose a format that makes the time scale clear without crowding the axis. If labels collide, widen the chart, reduce the font size, or use a less detailed date format.

In the Format Axis pane, Axis Options also lets you adjust the visible minimum and maximum and, where available, the major unit. Those settings control the displayed range and tick spacing, not the dates stored in the worksheet. If you enter bounds manually, use valid date values and check the resulting axis carefully; Excel may show the bounds as dates or as serial values depending on the field and interface.

Choose the right scatter style and time scale

Use markers only when you want to show separate observations without implying values between them. Use straight lines when connecting consecutive measurements helps readers follow a trend. A smoothed line can make a series look continuous, but it does not add real observations between dates and may suggest a shape that the data do not support. For most measured time series, markers with straight connecting lines are easier to interpret than a smoothed curve.

Think about the date range before setting the scale. A chart covering one week can show daily labels; a chart covering several years may be clearer with monthly or yearly intervals. Too many tick labels make the axis unreadable. Conversely, a very broad range can make a short period of change look compressed. Adjust the axis bounds to focus the chart, but do not hide important context or make small fluctuations appear larger than they are.

Dates can include times as well. Excel represents the time portion as a fraction of a day, so readings taken at 9:00 a.m. and 3:00 p.m. can occupy different horizontal positions on the same date. To show that detail, format the axis with a date-and-time display, for example dd-mmm hh:mm. If the chart is intended to compare days rather than times of day, use date-only labels while retaining the underlying timestamps.

Check and edit the chart series

If Excel assigns the wrong values to the axes, edit the series directly. Select the chart, then use Chart Design > Select Data. In the Select Data Source dialog, select the series and choose Edit. Confirm that Series X values refers to the date cells and Series Y values refers to the measurement cells. The series name can point to the header cell. Remove any header row from the x- and y-value ranges, and make sure both ranges contain the same number of data rows.

This series editor is especially useful when the source columns are nonadjacent, when a chart was created from a larger table, or when Excel guessed the orientation incorrectly. You can also use Select Data to add another series, such as a second measurement recorded on the same dates. Each series can have its own y-values, but it should use the intended date range for its x-values. If the series have different dates, assign each its own x-value range rather than assuming the first series’ dates apply to all of them.

When adding new rows later, a chart based on an Excel table often expands with the table as data is added, depending on how the chart’s series references are set up. For a fixed cell range, newly entered rows may not appear automatically. Check the source range in Select Data if the chart stops before the latest date.

Common problems and what they mean

The axis shows large numbers. The x-values may be genuine date serials, but the axis number format is General or Number. Apply a date format in Format Axis > Number.
All points appear at evenly spaced positions. Confirm that the chart is an XY scatter chart rather than a line chart with a category axis. Also check that the x-values are real dates, not text labels.
The dates appear in the wrong order. Sort the source rows by date, then check the series ranges. A scatter chart positions points by x-value, but a connecting line follows the order of the points in the series.
Some points are missing. Look for blank, text, or error values in either column, and check whether the series range includes all intended rows. Hidden or filtered data can also affect what a chart displays, depending on the chart’s settings.
Several points overlap. They may share the same date or have dates close together relative to the full chart range. Use a wider chart, a shorter date range, or a different marker style to make dense observations easier to inspect.
Dates are being interpreted inconsistently. Imported text, regional date conventions, and mixed date formats can cause ambiguity. Verify the actual cell values and convert the source data to consistent Excel dates before relying on the plot.

Scatter chart versus line chart

The key distinction is not whether a chart can display date-looking labels; both chart types can. It is how Excel spaces the horizontal positions. A scatter chart treats x-values as numbers, so a seven-day gap takes seven times as much horizontal space as a one-day gap. A line chart commonly spaces category labels evenly, which can be helpful when every observation is one category or when equal spacing is desired regardless of elapsed time.

For example, suppose a sensor records values on 1-Jan, 2-Jan, and 10-Jan. A scatter plot shows the first two observations close together and leaves a longer interval before the third. A category-based line chart may place all three labels at equal intervals. Use the scatter chart when the actual time gaps matter; use a line chart when the sequence of categories matters more than the distance between dates.

Frequently Asked Questions

Can an Excel scatter plot use dates as x-values?
Yes. Excel dates are numeric serial values, so a scatter chart can use them as x-coordinates. Format the horizontal axis as a date if it displays serial numbers.

Why does my scatter plot show numbers instead of dates?
The axis is displaying the date serial values with a numeric format. Right-click the horizontal axis, choose Format Axis, then select a date format under Number.

Should I use a scatter plot or a line chart for dates?
Use scatter when the actual gaps between dates should affect spacing, especially with missing or irregularly spaced observations. Use a line chart when equally spaced categories are more appropriate.

Can I show time as well as the date?
Yes. Store actual date-and-time values in the x-value column and apply a date-and-time axis format, such as dd-mmm hh:mm. Excel uses the fractional part of the date serial to represent time.

Can I put two measurements on the same date-based scatter plot?
Yes. Add a second series through Chart Design > Select Data > Add, then set its x-values to the date range and its y-values to the second measurement range. Use a legend and distinct markers or colors to identify the series.

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.