Fix Missing Charts in Microsoft Access Database Reports
Question details
Some users cannot see charts in a shared Microsoft Access database, even though other users can view the same charts normally.
- Product
- Microsoft Access for Microsoft 365
- Device & OS
- not provided
- Scenario
- Multiple users open the same Access database and need its chart controls and reports to display consistently.
- Observed behavior
- Affected users see blank reports or missing chart controls. In the reported case, an older Office build caused the issue, and updating Office through Software Center restored the charts.
On one affected computer and one working computer, open Access and record the version and build under File > Account > About Access. Confirm that both users are opening the same database file and report before comparing results.
Compare Office builds and update the affected computer
Use this first when the same database displays charts on some computers but not others. Updating the older Office build resolved the reported case.
In Access on both computers, select File > Account > About Access and compare the full version and build information. The same Microsoft 365 product name or version label does not guarantee identical builds.
On the affected computer, go to File > Account > Update Options > Update Now if that option is available. If your organization manages Office through Software Center, open Software Center and install the approved Microsoft 365 or Office update; contact IT if no update is listed.
After the update finishes, close and reopen Access, then open the same database and report that previously showed missing charts. Return to File > Account > About Access to verify the build changed.
Check modern chart support and consider legacy chart controls
Use this when updating is unavailable or you need to determine whether the affected Access installation supports modern charts.
Repair Office if charts remain missing after updating
Use this if the affected computer has a suitable Office build but Access still fails to display charts.
Use WPS Spreadsheet to Chart Data Exported from Access
WPS Office is a free, lightweight alternative for everyday document and spreadsheet work, with a familiar interface and Microsoft Office format compatibility. It does not open Access databases or repair Access chart controls, but you can export Access data to Excel and use WPS Spreadsheet to create charts, making it easier to move spreadsheet-based reporting workflows.

Frequently Asked Questions
Why can one user see the Access charts while another cannot?
Different Office builds can provide different levels of support for modern Access charts. Compare File > Account > About Access on both computers. In this case, updating the older build restored the charts.
Everyone has Microsoft 365. Do we still need to compare build numbers?
Yes. The Microsoft 365 product name alone does not identify the installed build. Open Access > File > Account > About Access and compare the complete version and build details, not just the product label.
What should I do if Update Now is missing or disabled?
Your organization may manage Office updates centrally. Open Software Center and check for an approved Office update, or ask IT to deploy one. The reported issue was resolved through Software Center.
How can I check whether an Access installation supports modern charts?
Open a separate test database, select Create > Form Design, and look on the Design tab for Insert Modern Chart. Compare its availability with a working computer and share any differences with IT.
Can WPS Office open the Access database and fix its charts?
No. WPS Office does not replace Microsoft Access or repair charts inside .accdb or .mdb databases. For spreadsheet-based charting, select a table or query in Access, use External Data > Excel to export it, then open the exported workbook in WPS Spreadsheet and use Insert > Chart.




