How to Enable Gridlines in Microsoft 365 Modern Charts
Question details
The user wants to know how to enable gridlines and set custom horizontal-axis start dates 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.
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.
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.
Accept that gridlines and custom horizontal-axis starting dates cannot be enabled in the current version of Microsoft 365 Modern Charts.
Visit the official Microsoft 365 Roadmap online and search for 'Access' to monitor upcoming enhancements and planned chart improvements.
Open Microsoft Access, navigate to Help > Feedback in the top ribbon, and send a suggestion requesting the addition of gridlines for Modern Charts.

Revert to Classic Charts for Gridline Support
If having gridlines is absolutely essential for your database reports, you can use the legacy Classic Charts feature as a temporary workaround.
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. 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. Open data in WPS Spreadsheet: Launch WPS Office, select Spreadsheet, and open your newly exported data file.
- 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.

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.




