A date-looking horizontal axis may be a set of text categories rather than a time scale. Check stored dates, source ordering, and chart type together.
Inspect the source values
Compare the cell’s actual value with its display. Imported strings may resemble dates without being numeric dates. Parse only a documented source format, preserving the original field for reconciliation.
Check a date with an unambiguous day above twelve and dates spanning months or years. A valid date type can still contain a day/month interpretation error from an earlier import.
Review axis and chart setup
Double-click the chart and inspect its horizontal-axis range and chart type. A category chart can treat labels as categories, while a suitable continuous time or numeric axis represents spacing differently.
Sort complete source records chronologically when that is required for the chosen chart. Do not sort only the date column, which would detach dates from their measured values.
Check spacing and missing periods
Use a sample containing a short interval and a longer gap. Verify whether the chart’s spacing communicates elapsed time or merely category order, and label it appropriately.
Inspect missing observations separately from zero values. A blank month does not prove there was zero activity. Check axis labels at ordinary viewing size and confirm a known point maps to the correct date. Changing the date display format alone does not change the chart’s underlying category model or repair text inputs. Keep the source and chart interpretations aligned before presenting a trend as evidence of timing, acceleration, or a sudden change.
References
- Add & edit a chart or graph
- Edit your chart's axes
- Types of charts & graphs in Google Sheets
- DATEVALUE
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.