Chart & Visualization Issues

How to Create a Chart from a Crosstab Query in Microsoft Access

Ayan Masood Oct 9, 2026 869 views

Question details

The user needs to create an accurate chart in an Access report based on a crosstab query, but the chart is missing critical axes.

How to Fix Missing Axes in Access Crosstab Query Charts

Product: Microsoft Access
Device & OS: not provided
Scenario: Creating a chart inside an Access report that visualizes data from a crosstab query.
Observed behavior: The Access chart fails to display the expected Fiscal Year and Donor Count axes, although the exact same crosstab data generates a correct chart when exported to Excel.

Before you start

Before modifying your chart properties, verify that your underlying crosstab query runs successfully on its own and explicitly outputs the required row and column headings.

Solution 1Recommended

Base the Chart on the Pre-Crosstab Intermediate Query

Access charts often struggle to interpret the dynamic column headings generated by crosstab queries. Pointing the chart to the underlying intermediate query resolves this.

By feeding the pre-crosstab data directly into the chart, the Access charting engine can group and plot the data natively without failing on missing dynamic fields.

Open Report in Design View

Launch your Access database, navigate to the Navigation Pane, right-click the report containing your chart, and select Design View.

Access Chart Properties

Click on the chart control to select it. Press F4 to open the Property Sheet on the right side of your screen.

Change the Row Source

In the Property Sheet, go to the Data tab. Change the 'Row Source' property from your crosstab query to the intermediate query (the query used to filter the data before the crosstab transformation).

Verify Field Names

Ensure that this intermediate query explicitly returns clearly named fields for your axes, such as 'Fiscal Year' and 'Donor Count', so the chart can recognize them.

Base the Chart on the Pre-Crosstab Intermediate Query

Alternative Approach: If the intermediate query is properly formatted, the Access chart engine will automatically aggregate the Fiscal Year and Donor Count correctly, bypassing the crosstab limitations entirely.

Solution 2

Verify Link Master and Child Fields Parameters

Checking link fields ensures that your chart properly synchronizes its parameters with the main report data.

Free Microsoft Office alternative

Use WPS Office for Powerful Data Visualization

Microsoft Access has rigid charting limitations, especially when handling dynamic crosstab data. WPS Office offers a free, lightweight, and highly compatible alternative. By exporting your query data, you can use WPS Spreadsheet to create stunning, dynamic charts with a familiar and much more flexible interface.

1. Export Your Access Data: Right-click your crosstab query in Access, select 'Export', and choose 'Excel' to save your data as an .xlsx file.
2. Open in WPS Spreadsheet: Launch WPS Office and open the newly exported Excel file.
3. Insert a Dynamic Chart: Highlight your data, navigate to the 'Insert' tab, and click 'Chart' to easily generate and customize your visual report.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless data transfer.Advanced charting tools that effortlessly visualize complex crosstab and pivot data.Free and lightweight, avoiding the heavy resource load of database software.Familiar, intuitive interface that requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my chart axes disappear when using a crosstab query in Access?

Access charts require static, predefined fields to plot axes. Crosstab queries generate dynamic column headings that the Access chart engine often cannot parse, which causes the axes to render blank or missing.

Can I export my Access crosstab query to chart it in another application?

Yes. Because spreadsheet tools are much better equipped for complex data visualization than Microsoft Access, you can export your crosstab query results directly to an Excel file and create your charts in WPS Spreadsheet or Microsoft Excel.

What are Link Master Fields in an Access report chart?

Link Master Fields and Link Child Fields are properties used to synchronize the data inside a chart with the current record of the main report. They ensure the chart only displays data relevant to the specific grouping or record being viewed.

Excel & Data Problems