Excel Graph Not Showing Dates Correctly? Fix the Axis

If an Excel graph is not showing dates correctly, first check that the source cells contain real Excel dates, then select the horizontal axis and set it to a date axis or format its numbers as dates. The right fix depends on whether Excel is treating your dates as text, displaying date serial numbers, or spacing the chart by categories instead of elapsed time.

How Excel dates and chart axes work

Excel stores most dates as serial numbers: each date corresponds to a number, and a time is represented as a fraction of a day. The cell’s number format makes that value look like a calendar date. A chart can use the underlying number to position a point, or it can treat the entry as a text label. That difference explains many date-axis problems.

A line chart normally uses a category axis along the bottom. Excel can space those categories evenly, even if the dates are separated by different amounts of time. A date axis instead uses calendar intervals, so the distance between points reflects the elapsed time. For example, dates on March 1, March 2, and March 20 may appear as three equally spaced categories on a text axis, but the date axis leaves a much larger gap before March 20.

An XY (scatter) chart works differently: its horizontal axis is a value axis. Excel can plot genuine date serial values along it and space points according to their numeric dates. This is often the better choice when exact time intervals matter, or when the horizontal values are dates and the vertical values are measurements.

Confirm that the source cells are real dates

Changing the chart’s axis format cannot turn text into dates. A cell may look like a date but contain text copied from a website, CSV file, or another system. A quick check is to select a source cell and look at the formula bar and the Number Format controls on the Home tab. You can also temporarily change the cell format to General: a real date usually appears as a serial number, while date text remains text. Restore the desired date format afterward.

Check a few entries rather than assuming the whole column has the same data type. A column can contain a mixture of real dates and text dates, particularly after imports or manual edits. Watch for leading apostrophes, spaces, inconsistent separators, and values such as 2025-03-04 that may be interpreted differently under different regional settings. An entry such as 03/04/2025 is especially ambiguous: it can mean March 4 or April 3, depending on the convention used.

To convert a straightforward text-date column, try selecting it and using Data > Text to Columns. Choose Delimited, click Next twice, select Date in the column data format, choose the order that matches the source (such as MDY or DMY), and click Finish. Check the results before charting. If the values include a format Excel cannot parse or mixed date conventions, clean or standardize the source first; choosing the wrong order can produce valid-looking but incorrect dates.

Set a line chart to use a date axis

In Excel for Microsoft 365 on Windows, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, open Axis Options and find Axis Type. If available, choose Date axis rather than Text axis. You can also leave the type on Automatically select based on data, but choosing Date axis explicitly can help when Excel has guessed incorrectly.

Use this setting when your source dates are genuine dates and you want calendar-based spacing or date intervals. In the same pane, review the units and bounds. Depending on the chart and data, Excel lets you control the base unit or the major interval, such as showing a label every month rather than every day. A major interval changes how often labels or tick marks appear; it does not change the underlying date values.

If Axis Type does not offer Date axis, check the chart type and the selected axis. Date-axis controls are associated with category axes, such as those in line charts; they are not the way to configure a scatter chart’s horizontal value axis. Also confirm that you clicked the horizontal axis rather than the vertical axis or a data series.

Format dates instead of seeing serial numbers

If the chart shows numbers such as 45717 along the horizontal axis, those may be valid date serials displayed with a General or numeric format. Right-click the horizontal axis, choose Format Axis, and open the Number section. Select a date format, or enter a suitable format code, then apply it. A format changes how the value is displayed, not the date itself.

For example, a short format such as mmm-yy can make a long daily series easier to scan, while d-mmm can distinguish individual days. If the axis is crowded, shortening the date format may help, but it will not fix incorrect spacing. Use Axis Options to adjust the interval as well. If changing the axis format has no effect, the chart may be using text categories, or the source entries may be stored as text rather than numeric dates.

Cell formatting and chart-axis formatting are separate. Formatting the worksheet’s source cells as dates does not always make the chart labels use the same format. Likewise, changing the chart axis does not alter the source data. If the chart displays labels taken from a separate range, verify that the selected category-label range is the intended date column.

Choose between a line chart and a scatter chart

Choose a line chart when the points represent an ordered sequence and you want a familiar time-series presentation. A date axis can show calendar spacing, while a text axis can be useful when every observation should receive equal visual space regardless of the time gap. For example, monthly reports with one value for each month are often clear on a line chart, even if a month is missing.

Choose an XY (scatter) chart when the horizontal position must reflect actual numeric distance between dates, or when observations are irregularly spaced. Select the date values and measurement values as the chart’s X and Y data, then format the scatter chart’s horizontal value axis with a date number format. Because dates are numeric serials, a scatter chart can position them chronologically. If you see serial numbers, format the value axis as dates; if the points appear in the wrong order, sort the source data by date.

Neither chart type automatically answers every question. A line chart with equally spaced categories may communicate a sequence more clearly, while a date or scatter axis conveys elapsed time. Decide whether the gaps between dates matter to the story before changing chart types.

Fix labels, intervals, and unexpected gaps

When every date appears and the labels overlap, reduce the number of displayed labels by changing the major interval or using a shorter date format. For a long daily series, showing one label per month or quarter may be more readable than labeling every observation. The chart can still plot each data point even when it labels only selected dates.

If dates appear in an unexpected order, inspect the source column. Text dates may sort alphabetically rather than chronologically, so values can appear as April, August, December, and so on instead of in calendar order. Convert them to real dates, then sort the source rows by the date column. Also check whether the chart’s category labels point to the right range and whether a filter or hidden rows have changed what is displayed.

Large gaps can be correct when there are long periods between observations. If a line chart uses a date axis, weekends, holidays, or missing periods may affect the spacing because calendar time continues through those intervals. If you want observations equally spaced despite those gaps, a text axis may be more suitable. This is a presentation choice, not necessarily a data error.

Check blanks, times, and workbook date systems

Blank cells and zero values can create confusing chart behavior. A blank may produce a gap, be treated as zero, or be connected across, depending on the chart settings and how the blank is represented. To review the chart’s behavior, select the chart and use Chart Design > Select Data > Hidden and Empty Cells. The available options depend on the chart type. A cell containing a formula that returns an empty string is not always treated identically to a truly empty cell.

Dates that include times can also look repetitive if the axis format shows only the day. Two observations on the same date may be distinct values because their time fractions differ, even though both labels display the same calendar date. If the time matters, use a format that includes hours or minutes and adjust the axis scale. If only the date matters, consider whether the source should be grouped or summarized by day.

Excel workbooks can use different date systems, notably the 1900 and 1904 systems. When data is copied between workbooks that use different systems, dates can shift. This is less common than text conversion or axis formatting issues, but it is worth checking if a whole range is consistently offset after a workbook transfer. In Windows, review File > Options > Advanced, under When calculating this workbook, for the Use 1904 date system setting. Avoid changing it casually in an established workbook, because it can affect existing date values.

A practical troubleshooting order

Work from the source data toward the chart so you do not mask a data problem with formatting:

Confirm that the chart’s horizontal labels come from the intended date range.
Check several source cells to make sure they contain numeric Excel dates, not text or a mix of both.
For a line chart, open Format Axis and choose Date axis if calendar spacing is required.
Set a readable date number format and adjust the major interval if labels are crowded.
For irregular time intervals, consider an XY (scatter) chart and verify that dates are used as its X values.
Inspect sorting, blanks, hidden rows, date-time values, and workbook date-system settings if the display is still unexpected.

On Excel for Mac, the same general approach applies, although pane layouts and some command locations can differ by release. In Excel for the web, chart formatting options may be more limited than in the Windows desktop application. If a particular axis control is unavailable in the web version, open the workbook in the desktop app to check it.

Frequently Asked Questions

Why does my Excel chart show numbers instead of dates?
Excel may be displaying date serial values with a numeric format. Format the chart axis as a date in Format Axis > Number. If the format does not change the labels, check whether the source values are text or whether the chart is using a different label range.

How do I stop Excel from treating dates as text?
Convert the source entries into real dates, taking care to use the correct order for month, day, and year. Data > Text to Columns can convert consistently formatted text dates when you select the matching date order. Verify the converted values before relying on the chart.

Why are my dates equally spaced when the time gaps are different?
Your line chart may be using a text axis, which gives each category equal space. Choose Date axis for calendar spacing, or use an XY (scatter) chart when the horizontal position must reflect numeric time differences.

Why does Excel skip some date labels?
Excel may suppress labels to prevent them from overlapping, or the axis interval may be set to show only selected dates. Increase the chart width, shorten the date format, or adjust the major interval in Format Axis. Skipped labels do not necessarily mean the data points are missing.

Can I show dates on a scatter chart?
Yes. Use real Excel dates as the scatter chart’s X values, then format its horizontal value axis with a date format. The chart plots the dates as serial numbers but can display them as calendar dates.

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.