Others

How to Enable Gridlines in Microsoft 365 Modern Charts

Algirdas JasaitisAlgirdas Jasaitis Oct 7, 2026 868 views

Question details

The user wants to know how to enable gridlines and set custom horizontal-axis start dates in Microsoft 365 Modern Charts.

How to Enable Gridlines in Microsoft 365 Modern Charts
Product
Microsoft 365 Access
Device & OS
not provided
Scenario
Customizing and formatting the appearance of a Modern Chart for better data visualization in a database report.
Observed behavior
Gridlines and manual horizontal-axis starting dates are currently unsupported and unavailable in the Modern Charts feature.
Before you start

Verify whether you are using the new Modern Charts or the older Classic Charts in your Microsoft Access database, as their formatting capabilities differ significantly.

Solution 1Recommended

Review Current Limitations and Submit Feature Feedback

Since Modern Charts currently do not support gridlines natively, the best approach is to understand the limitation and submit feedback to prioritize the feature in future updates.

Microsoft Access Modern Charts were introduced to provide a refreshed look, but they currently lack some of the detailed formatting options found in legacy charts. The Access development team is aware of this limitation.

1
Acknowledge chart limitations

Accept that gridlines and custom horizontal-axis starting dates cannot be enabled in the current version of Microsoft 365 Modern Charts.

2
Check the Microsoft 365 Roadmap

Visit the official Microsoft 365 Roadmap online and search for 'Access' to monitor upcoming enhancements and planned chart improvements.

3
Submit feedback to Microsoft

Open Microsoft Access, navigate to Help > Feedback in the top ribbon, and send a suggestion requesting the addition of gridlines for Modern Charts.

Review Current Limitations and Submit Feature Feedback
Future Updates: Gridlines have been identified by the Microsoft Access team as an item on their list of planned improvements, though an exact release date is unknown.
Free Microsoft Office alternative

Create Fully Customizable Charts with WPS Office

If you are frustrated by the missing formatting features in Microsoft 365 Access Modern Charts, consider exporting your data and visualizing it using WPS Spreadsheet. WPS Office offers robust chart creation tools that fully support gridlines, custom axis dates, and highly detailed formatting.

  1. 1. Export your database records: In your current database program, export the query or table you want to visualize as an Excel (.xlsx) or CSV file.
  2. 2. Open data in WPS Spreadsheet: Launch WPS Office, select Spreadsheet, and open your newly exported data file.
  3. 3. Insert and format your chart: Highlight your data, go to the Insert tab, select your desired chart type, and use the Chart Elements menu to easily enable and customize your gridlines.
Full support for customizing chart gridlines, axes, and visual elements.Seamless compatibility with Microsoft Excel (.xlsx) formats.Lightweight, free to use, and features a highly familiar user interface.Easily import database query results to create professional, presentation-ready charts.
microsoft office alternative - wps office

Frequently Asked Questions

Will gridlines be added to Microsoft 365 Modern Charts in the future?

Yes, the Microsoft Access development team has acknowledged the lack of gridlines and identified it as a planned improvement. You can track its progress by reviewing the Microsoft 365 Roadmap.

Can I manually set the horizontal axis start date in Modern Charts?

No. Just like gridlines, custom starting dates for the horizontal axis are currently unsupported in the Modern Charts feature.

What is the difference between Modern Charts and Classic Charts?

Modern Charts offer a more contemporary aesthetic and easier data-binding processes, while Classic Charts (which rely on older Microsoft Graph technology) look dated but support deeper granular formatting options like gridlines and custom scales.