Office Compatibility Issues

Fix Missing Charts in Microsoft Access Database Reports

Steven ParkerSteven Parker Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Compare the full build numbers

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.

2
Install the approved Office update

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.

3
Reopen the database and check the charts

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.

Confirmed resolution in this case: The affected computer had an older Office build. After Office was updated through Software Center, the user could see the charts.
Free Microsoft Office alternative

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.

Create spreadsheet charts from table or query data exported from Access.Supports Microsoft Excel .xlsx and .xls files for sharing exported data.Familiar spreadsheet controls make migration easier for Excel users.A lightweight office suite for everyday spreadsheet and document tasks.
QA img-9

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.