Excel Chart Displays the Wrong Month for a Date
Question details
The user needs to determine why an Excel chart assigns the wrong month to a date and how to isolate the cause.
- Product
- Microsoft Excel chart
- Device & OS
- not provided
- Scenario
- A chart displays January instead of March even though regional settings and axis formatting appear correct.
- Observed behavior
- The chart shows an incorrect month for one or more date values, potentially because the source dates are text, date serials are incorrect, the axis type is unsuitable, or the chart references the wrong range.
Create a small copy of the workbook containing only the relevant dates, labels, and chart. Remove confidential information, then confirm whether the source date cells contain real dates rather than text.
Verify the source dates and chart data range
Use this diagnostic approach when the chart label is wrong even though the visible date formatting appears correct.
Excel charts use the underlying date serial value and the selected source range, not only the displayed cell format. A cell that looks like a date may still contain text or an incorrect serial number.
Select each source date cell and check the formula bar. In a blank cell, use =ISNUMBER(A2), replacing A2 with the date cell; TRUE indicates a numeric Excel date, while FALSE may indicate text.
Select the affected date column, open Data > Text to Columns, choose the appropriate date format in the final step, and select Finish. Alternatively, use =DATEVALUE(A2) when the text follows a recognizable date format.
Right-click the chart and choose Select Data. Verify that the Horizontal (Category) Axis Labels and series ranges include the intended date cells and do not shift into adjacent rows or columns.
Temporarily format the source cells as General or Number from Home > Number Format. Compare the underlying serial values with the expected dates before restoring the date format.
Review the chart axis type and workbook date system
Use these settings when the source values are valid dates but the chart still groups or labels them under the wrong month.
Create and troubleshoot date-based charts with WPS Office
WPS Office provides a free, lightweight spreadsheet experience with a familiar interface for checking date values, selecting chart ranges, and adjusting date-axis settings. It supports seamless migration of compatible Excel workbooks while preserving common .xlsx chart and spreadsheet workflows.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, choose Spreadsheet, and open the compatible .xlsx workbook from the Home screen.
- 2. Check the source date cells: Select the date column and use the formula bar or Home > Number Format to confirm that the values are recognized as dates rather than text.
- 3. Review the chart settings: Select the chart, open the chart formatting or axis options, and verify the category range, axis type, date units, and displayed number format.
Frequently Asked Questions
Why does an Excel chart show January when the source cell displays March?
The source cell may contain text, an incorrect date serial number, or a value from a different date system. Test the cell with =ISNUMBER(cell_reference), then compare its underlying number with the expected date.
How can I tell whether an Excel date is stored as text?
Select the cell and inspect the formula bar, or use =ISNUMBER(A2). A TRUE result means Excel recognizes the value as a number/date; FALSE suggests the value is text or otherwise invalid for a date axis.
Which axis type should I use for dates in an Excel chart?
Use Date axis for continuous dates that should be spaced according to time. Use Text axis when each label should be treated as a fixed category rather than a chronological date value.
Where can I verify the chart's source range?
Right-click the chart, select Select Data, and review the series ranges and Horizontal (Category) Axis Labels. Make sure the ranges point to the intended date cells and have not shifted.
Can the Excel 1904 date system cause incorrect chart months?
Yes. Workbooks using different date systems can interpret the same serial number differently. Check File > Options > Advanced > When calculating this workbook and compare the 1904 date system setting with the source workbook.
