Excel Scatter Plot With Dates: Setup and Formatting

To make an Excel scatter plot with dates, put real Excel dates in one column and the corresponding numeric values in another, select both columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. If the horizontal axis shows serial numbers, format that axis as a date; scatter charts use the underlying date values as numeric X coordinates.

How dates work on a scatter chart

Excel stores a date as a serial number: the number represents days from a starting point, and a time of day is stored as a fraction of a day. A scatter chart plots those numbers on a continuous horizontal value axis. This is useful when observations are not evenly spaced, because the chart can show the actual elapsed time between dates rather than giving every observation the same horizontal gap.

For example, suppose you recorded a river level on January 2, January 3, and January 10. A scatter chart places the last reading seven days after the second one. A chart that treats the dates only as categories may space all three observations equally, concealing the longer gap. The two charts can look similar when measurements occur at a regular interval, but the difference matters when dates are missing or irregular.

In a scatter chart, date formatting affects how the axis numbers are displayed; it does not change the observations’ positions. If Excel has dates stored as text instead of date values, formatting the axis alone will not fix the data. Confirm that the cells contain genuine dates before building the chart.

Prepare the date and value columns

Arrange the data in two columns with one observation per row. Put dates in the first column and the measurement or other numeric value in the second. A simple example might have Date in A1, Daily visitors in B1, and a date and visitor count on each row below. Column headings help Excel identify series names and make the chart easier to interpret.

Use a consistent date format, such as 2026-01-15, so dates are easy to read and less likely to be confused across regional settings.
Keep the X values and Y values aligned row by row. A date in one row must correspond to the measurement beside it.
Check that dates are real Excel values, not text copied from a website or imported system. Select a date cell and temporarily choose Home > Number Format > General. A real date usually displays as a serial number; change the format back afterward.
Keep blanks genuinely blank if no observation exists. Do not enter a zero measurement to mean missing data unless zero is the true value.

Text dates can sometimes be converted by selecting the affected column and using Data > Text to Columns, then choosing the appropriate date order in the final step before finishing. The correct order depends on the source: for example, 03/04/2026 could mean March 4 or April 3. Check a few converted values before charting. If a date has a time as well, preserve it as an actual date-and-time value; Excel can plot the time fraction between days.

Create the scatter plot in Excel

Select the date and value columns, including their headings, if they are next to each other. If they are separated, select the date range, then hold Ctrl on Windows while selecting the value range. On Mac, use Command while selecting the second range.
Open Insert > Insert Scatter (X, Y) or Bubble Chart and choose the basic Scatter option, usually the first icon. This creates points without connecting lines. Choose a subtype with straight lines or smooth lines only if connecting observations is appropriate for the story you want the chart to tell.
Inspect the result. The dates should determine horizontal position and the measurements should determine vertical position. If Excel put the wrong information on an axis, right-click the chart and choose Select Data. Edit the series, setting the date range as Series X values and the measurement range as Series Y values.
Add labels and titles that explain the data. Select the chart, then use Chart Design > Add Chart Element > Chart Title or Axis Titles. A useful horizontal title might be Date recorded; the vertical title should include the measurement and, where relevant, its unit.

The exact ribbon layout can vary slightly with window size and Excel updates, but the scatter-chart command is on the Insert tab. In Excel for Mac, use the Insert tab and the Scatter chart controls as well; chart formatting is available by selecting or Control-clicking the axis. Excel for the web offers chart insertion and common formatting options, although some detailed controls may differ from the Windows desktop version.

Format the horizontal axis as dates

If the horizontal axis displays values such as 46037 instead of calendar dates, the plotted positions may already be correct: the axis simply needs a date number format. Right-click the horizontal axis and choose Format Axis to open the formatting pane. Under Axis Options, verify that the axis bounds and units give a useful view of the data. Then expand Number, choose a Date category or enter a suitable custom date format, and apply it. Formats such as mmm d or yyyy-mm-dd can make a crowded axis easier to read.

Choose the format for the amount of time being shown. A chart covering a few weeks might use a month-and-day label, while a chart covering several years may be clearer with month and year. Avoid labels so detailed that they overlap. You can make the chart wider, reduce the font size, or show fewer labels by adjusting the major unit. On a scatter chart, the horizontal axis is numeric, so its major unit is a number of days: a unit of 7, for example, corresponds to seven-day spacing. A fixed number of days does not equal a calendar month, since months have different lengths.

Axis limits can also focus the chart on a particular period. When editing bounds, remember that dates are serial numbers internally; use the displayed dates in the data as a reference and check the result after applying changes. Resetting the bounds to automatic is a useful way to return to the full data range. Formatting the axis changes its labels, while changing bounds or units changes the visible range or tick spacing.

Uneven dates, missing days, and date-time values

One reason to choose an XY scatter chart is that the distance between points reflects elapsed time. This is valuable for lab readings taken when convenient, project milestones, equipment failures, market observations, or any record with skipped dates. A missing day is not automatically a zero or a data point; it is simply an interval with no observation. If the chart connects points with lines, the line spans that interval, so readers should not mistake the connecting line for measurements taken on every intervening day.

If dates are accompanied by times, Excel can place readings from the same day in chronological order because time is represented as part of the serial value. For example, 9:00 a.m. and 3:00 p.m. fall six hours apart, not at the same horizontal position. Use an axis format that includes time when those differences matter. If the chart covers many days, displaying time in every tick label may be cluttered; a concise date axis with time details in data labels or a nearby table may be clearer.

Dates entered in a different date system can complicate copied data. Excel workbooks can use different date systems, and transferring raw serial values between workbooks that use different systems can shift dates. Copying and pasting displayed dates, or checking the workbook’s date-system setting when imported dates look consistently offset, can help diagnose that special case.

Plot multiple series against the same dates

To compare two measurements over time, assign each measurement column its own Y range while using the same date range for its X values. For example, a table could contain Date, Indoor temperature, and Outdoor temperature. Add the first pair as one series and the second pair as another. In Select Data, edit or add a series and specify its name, X values, and Y values. The X ranges for both series should cover the same dates, and each Y range should have the same number of rows as its X range.

Different scales can make comparisons misleading. If one series is measured in single digits and another in thousands, the smaller values may appear nearly flat on a shared vertical axis. Consider separate charts or, where appropriate, a secondary vertical axis. A secondary axis should be labeled clearly because readers can otherwise assume both lines use the same scale. Also check that colors, markers, and a legend make each series identifiable without relying on color alone.

Common problems and how to fix them

The axis shows large numbers. Apply a date number format to the horizontal axis. If that does not produce dates, check whether the source cells contain real dates rather than text.
Points appear in the wrong order or at unexpected positions. Confirm that Excel is using the date range for X values and the measurement range for Y values. A scatter chart does not infer the intended date column correctly in every layout.
All points are equally spaced. Check that you inserted an XY scatter chart rather than a chart that uses categories. Also check the underlying dates: if the observations truly are evenly spaced, equal-looking gaps are expected.
Some dates are missing or become blank. Look for text values, empty cells, error values, or inconsistent imported formats in the source column. A cell that looks like a date may still be text.
Labels overlap or the chart is hard to read. Use a shorter date format, reduce the number of displayed ticks by changing the major unit, widen the chart, or show a shorter date range.

When troubleshooting, change one thing at a time. First verify a few source cells, then inspect the series ranges, and only after that adjust axis formatting. This separates data problems from display problems and avoids changing correct values just to make the chart look different.

Scatter chart or line chart?

A line chart is often a good choice for regularly spaced daily, monthly, or yearly observations, especially when the horizontal axis should show each date as a category. Excel line charts use a category axis, which can display date labels while spacing categories evenly. That can be useful for monthly reports where every month deserves the same visual width, even if the calendar months have different lengths.

Choose a scatter chart when the actual numeric spacing between dates matters, when observations are irregular, or when date and time values need continuous positions. Choose a line chart when equal spacing between reporting periods is intended and the category sequence matters more than elapsed time. Neither type is universally better: the right choice depends on whether horizontal distance should represent real time or an ordered list of periods.

Frequently Asked Questions

Can Excel use dates on the X-axis of a scatter plot?
Yes. Excel stores dates as numeric serial values, and a scatter chart can use those values 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 chart may be plotting the dates correctly but displaying their serial numbers. Right-click the horizontal axis, choose Format Axis, and change the Number format to a date. If that fails, confirm the source dates are not text.

Can a scatter chart show dates that are not evenly spaced?
Yes. This is a key reason to use a scatter chart: actual date values determine the spacing. A gap of ten days appears longer than a gap of one day.

Should I use a scatter plot or a line chart for dates?
Use a scatter plot when elapsed time and irregular gaps matter. Use a line chart when you want evenly spaced categories such as monthly reporting periods, or when the order of periods matters more than the exact number of days between them.

Can I show times as well as dates?
Yes. If the source values contain real date-and-time values, a scatter chart can plot their fractional-day differences. Apply an axis number format that includes time when the time-of-day spacing is important.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.