Chart & Visualization Issues

How to Fix Access Modern Chart Axis Showing Numbers Instead of Dates

Anum MushtaqAnum Mushtaq Nov 3, 2026 870 views

Question details

The user needs calendar dates to display correctly on the axis of an Access Modern Chart instead of numerical values.

How to Fix Access Modern Chart Axis Showing Numbers Instead of Dates
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Design View

Right-click the Form or Report containing your Modern Chart in the Navigation Pane and select Design View.

2
Access Chart Settings

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.

3
Modify the Chart Type

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.

Change to a Date-Friendly Chart Type
Chart Type Selected: Scatter charts are highly recommended for pinpointing exact completion dates on an axis.
Free Microsoft Office alternative

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. 1. Export Access Data: In Microsoft Access, right-click your query or table, select Export, and choose Excel Workbook.
  2. 2. Open in WPS Spreadsheet: Launch WPS Office and open the exported .xlsx file using the Spreadsheet application.
  3. 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.
Free, lightweight, and incredibly fast to installFully compatible with Microsoft Excel formats (.xlsx and .xls)Intuitive chart creation with automatic date-axis recognitionFamiliar user interface requiring no learning curve
QA img-9

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.