Fix Excel Chart X-Axis Date Labels That Stop Displaying
Question details
The user needs an Excel chart's horizontal date labels to cover the full intended data range instead of stopping at an earlier date.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel chart contains data for later dates, but the visible horizontal axis labels or the selected axis-label range appear to end sooner.
- Observed behavior
- The chart displays data beyond the last visible date label. A restricted axis maximum, date-axis settings, label spacing, or an incomplete source label range may explain the mismatch.
Identify the last date that should appear and locate its cell in the chart's source data. Check the chart type: line and column charts use category labels, while XY scatter charts use numeric X values and require a different source-data check.
Check the horizontal axis maximum and date-label spacing
Use this first when the source dates are complete but the visible labels stop early or skip expected dates.
Select the chart, right-click its horizontal axis, and choose Format Axis. Open Axis Options in the formatting pane.
If Bounds is available, check Maximum against the latest date in your source data. Reset a fixed maximum to Auto, or set it to the intended ending date. Excel may display date bounds as date serial numbers.
For a line or column chart, review Axis Type under Axis Options. Choose Date axis when you want spacing based on calendar time, or Text axis when you want each source category spaced equally. These options are not available for every chart type.
For a date axis, review the Major unit and its time unit; reduce the interval if too few dates are labeled. If Labels offers Interval between labels, set it to 1 to display each category label. Widen the chart if the labels become crowded.
Click outside the formatting pane and inspect the chart. Confirm that the axis covers the intended ending date; if it still stops early, check the source label range using the next solution.

Extend the axis-label range to include all required dates
Use this when Select Data shows a label range that ends before the final date in the worksheet.
Review Excel Chart Data in WPS Spreadsheet
WPS Office is a free, lightweight, easy-to-use alternative for opening Excel workbooks and reviewing chart source data. Its familiar spreadsheet interface and Excel format compatibility support a smooth move to everyday spreadsheet work, though it does not repair Microsoft Excel's axis settings.

Frequently Asked Questions
Why does my Excel chart show data after the last visible date label?
Axis labels can be spaced at regular intervals, so the last printed label may occur before the last data point. Right-click the horizontal axis, choose Format Axis, and review the Major unit or label interval before assuming that data is missing.
Where do I change the maximum date on the horizontal axis?
Right-click the horizontal axis and choose Format Axis > Axis Options. If Bounds is available, reset Maximum to Auto or set the intended ending date. If Bounds is absent, check the axis type and source label range instead.
Should I use a Date axis or a Text axis?
In Format Axis > Axis Options > Axis Type, choose Date axis to represent calendar gaps proportionally. Choose Text axis to space every source category equally. A Text axis does not preserve the relative length of gaps between dates.
How do I include new worksheet dates in an existing chart?
Right-click the chart and choose Select Data. Use Horizontal (Category) Axis Labels > Edit to extend the date range, then edit each relevant series so its values cover the matching rows.
Why can't I edit category labels for my scatter chart?
An XY scatter chart uses numeric X values rather than category labels. Go to Select Data, select the series, and click Edit to update Series X values and Series Y values. Then use Format Axis to review the horizontal bounds.




