How to Fix Access Modern Chart Axis Showing Numbers Instead of Dates
Question details
The user needs calendar dates to display correctly on the axis of an Access Modern Chart instead of numerical values.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to create a bar chart or timeline to show the end dates of specific items using the Modern Chart feature.
- Observed behavior
- The chart axis displays numeric decimal values, such as 0, 0.2, and 0.4, rather than the expected calendar dates.
Verify that your underlying table or query includes both a valid date/time field and a measurable numeric value, as Modern Charts handle dates differently than legacy Classic Charts.
Change to a Date-Friendly Chart Type
Switching to a line or scatter chart allows Access to properly plot dates without requiring a separate measurable duration value.
A bar chart inherently compares measurable numerical values over a scale. If your goal is simply to map when each item ends without a corresponding magnitude, a bar chart is not the correct tool. Modern Charts in Access do not have all the auto-formatting date features of Classic Charts, so using a chart type designed for plotting specific timeline data points is necessary.
Right-click the Form or Report containing your Modern Chart in the Navigation Pane and select Design View.
Click on the Modern Chart to select it. The Chart Settings pane should appear on the right side of the screen. If it does not, click the Property Sheet and find the Chart Settings tab.
In the Chart Settings pane, look for the 'Chart Type' dropdown and change it from 'Bar' or 'Column' to 'Line' or 'Scatter'. The axis will re-evaluate and display dates.

Add a Start Date and Duration Value
If a bar chart format is strictly required, you must modify your data to include a measurable duration for the bar to render correctly against a date axis.
Easily Create Data Visualizations with WPS Office
While Microsoft Access is powerful for relational database management, configuring visualizations like Modern Charts can be unnecessarily complex. For seamless charting and date-axis formatting, consider exporting your data and using WPS Spreadsheet.
- 1. Export Access Data: In Microsoft Access, right-click your query or table, select Export, and choose Excel Workbook.
- 2. Open in WPS Spreadsheet: Launch WPS Office and open the exported .xlsx file using the Spreadsheet application.
- 3. Insert Chart: Highlight your date and data columns, navigate to the Insert tab, and select your preferred chart type. WPS will automatically detect and format the date axis.

Frequently Asked Questions
Why did my chart axis display dates correctly in older versions of Access?
Earlier versions of Access relied on Classic Charts, which included legacy formatting mechanisms that automatically guessed date scales even without proper values. Modern Charts use a newer rendering engine that requires explicit measurable data for bar graphs.
Can I simply format the Modern Chart axis properties to force it to show dates?
No. If the underlying chart type (like a Bar Chart) lacks a measurable value, it cannot resolve the timeline mathematically. Changing the format property alone will not convert the decimal values back to accurate dates.
How do I switch back to using Classic Charts in Access?
In Design View, navigate to the Design tab. Open the Controls gallery and look for 'Classic Chart' or 'Insert ActiveX Control' to select the legacy Microsoft Graph Chart object instead of inserting a Modern Chart.




