How to Add Charts to Reports in MS Access

Your database is packed with valuable data. But rows of numbers in a plain Access report? They tell almost nothing at a glance. Charts change that entirely — they turn raw figures into patterns, comparisons, and trends your audience can immediately understand and act on.

Data visualization is not a nice-to-have. Research consistently shows that visual representations of data help people identify trends, spot anomalies, and make faster decisions than reviewing spreadsheets alone. Companies across sectors — from consumer packaged goods to healthcare — rely on visual reporting tools to communicate performance and drive action. MS Access, which Statista still ranks among the top 10 database systems as of 2024, gives you a built-in charting engine directly inside your reports. You just need to know how to use it.

This guide walks you through exactly how to add charts to reports in MS Access — from choosing the right chart type, to binding it to your data, to customizing it for clarity. Whether you are running Access for Microsoft 365 or an older version, you will find the right method here.

Why Charts in Access Reports Actually Matter

Before jumping into the steps, it is worth understanding what charts give you that a standard Access report does not.

A well-placed chart in a report does three things at once. It compresses complex data into a single visual. It makes comparisons and trends obvious without requiring the reader to do mental arithmetic. And it makes your reports look professional and decision-ready rather than purely transactional.

Access supports a wide range of chart types — column, bar, line, area, pie, combo, scatter, bubble, funnel, waterfall, doughnut, radar, arc, box and whisker, and word cloud. That variety means you can match the chart type to the story your data is telling. Sales over time? Line chart. Category comparison? Clustered column. Part-to-whole breakdown? Pie or doughnut.

Access also lets you bind charts directly to a table or query, which means your chart updates automatically when your data changes. And if you are on Access for Microsoft 365, you can even make charts interactive — so filtering a report changes the chart values in real time.

The Two Chart Methods in MS Access

If you are using Access 2019 or Access for Microsoft 365, you have access to two chart engines:

• Modern Charts — the newer, more powerful option built on the “Ivy” charting package (the same engine used in Excel, Word, and PowerPoint). This is the recommended method going forward.
• Legacy Microsoft Graph Charts — the older chart control still available for backward compatibility. This is your only option in Access 2013 and earlier.

If you are on Access 2016 or older perpetual versions, any modern chart types you encounter will revert to a default Combo chart. In Access 2013 or earlier, modern charts will not appear at all — use the Chart Wizard method instead.

Start with modern charts if your version supports them. Fall back to the Chart Wizard if needed.

How to Add a Modern Chart to a Report in MS Access

Open Your Report in Design View

Go to the Navigation Pane, right-click your report, and select Design View. If you do not have an existing report, go to the Create tab on the Ribbon, click Report Design in the Reports group to start with a blank report.

Make your Report Header section tall enough to accommodate the chart. You can drag the section border down to create more space.

Insert a Modern Chart

On the Report Design Tools Design tab in the Ribbon, find the Controls group. Click the Insert Modern Chart dropdown. You will see a list of available chart types grouped by category — column, bar, line, pie, combo, and more.

Select your desired chart type. Your cursor will change to a crosshair. Click and drag on the report canvas to define the area where you want the chart to appear. Release the mouse to drop the chart control into place. Access will display a sample chart and the Chart Settings pane will open on the right side of the screen.

Bind the Chart to a Data Source

In the Chart Settings pane, the first thing to configure is the Data Source. Click the dropdown and select either a table or a query. Queries are often the better choice because they let you pre-filter and shape the data before it hits the chart.

Once you select a data source, the Chart Settings pane expands to show field mapping options.

Map Your Fields

You will see three key field slots to fill:

• Axis (Category) — the horizontal axis, typically a date, category, or name field
• Legend (Series) — used for grouping data into separate series (optional)
• Values (Y Axis) — the numeric field you want to measure

Drag and drop fields from the field list into the appropriate slots, or use the dropdowns to select them. By default, Access automatically applies aggregate functions (Sum, Count, Average) to numeric fields and groups the results. You can change or remove the aggregation using the dropdown next to each field.

When you select a date field for the axis and there is one value per period, Access will format the axis labels to show the relevant time unit automatically.

Preview Your Chart in Layout View

Switch to Layout View to see your chart populated with real data. In Design View, Access shows only a sample placeholder — your actual data only appears in Layout View or Print Preview.

Resize the chart control by dragging its edges until the chart is readable and proportional. Check that axis labels are not overlapping, that the legend is positioned cleanly, and that the chart title (if shown) is accurate.

How to Add a Legacy Chart Using the Chart Wizard

If you are on an older version of Access, or if you need the legacy Microsoft Graph chart control for compatibility reasons, use this method.

Enable the Control Wizards

In Report Design View, go to the Report Design Tools Design tab. In the Controls group, click the small arrow in the bottom-right corner of the control list to expand it. Make sure the Use Control Wizards button is toggled on (it should appear highlighted). This ensures the Chart Wizard launches automatically when you insert a chart.

Insert the Chart Control

In the same Controls group, find and click the Insert Chart button (it looks like a small bar chart icon). Click and drag on the report canvas to define the chart area. When you release the mouse, the Chart Wizard dialog box opens.

Select Your Data Source

In the first screen of the Chart Wizard, choose whether to pull data from a Table, a Query, or Both. Select the specific table or query you want to use, then click Next.

Choose Your Fields

In the next screen, you will see a list of available fields from your selected data source. Double-click the fields you want to include in the chart to move them to the Fields for Chart list. Select the fields that represent your categories and your numeric values. Click Next.

Choose a Chart Type

The Chart Wizard presents a grid of chart type icons. Select the type that best fits your data — column, bar, line, pie, area, doughnut, 3D variants, and others are all available. Click the one you want and click Next.

Arrange Your Data

In the next screen, Access shows a preview of how it has mapped your fields to the chart. You can drag and drop the field buttons to change which field goes on the axis, which becomes the data series, and which provides the values. Adjust until the preview looks correct, then click Next.

Add a Title and Legend

In the final screen, type a title for your chart. Choose whether to include a legend. Click Finish to add the chart to your report.

Switch to Layout View to see your chart with real data and resize it as needed.

Customizing Your Chart for Clarity

Adding a chart is just the start. A chart that is not formatted for your audience is just as hard to read as a table of numbers.

Edit Chart Title and Labels

In the Chart Settings pane (modern charts) or by double-clicking the chart to enter Microsoft Graph editing mode (legacy charts), you can update the chart title, axis titles, and data labels. Always include a clear, descriptive title — never leave it as “Chart1” or blank.

For modern charts, go to the Format tab in the Chart Settings pane to type a Display Name and adjust colors. You can also toggle Display Data Labels on or off here.

Change the Color Scheme

Consistent, readable colors matter. Avoid using red and green together (for accessibility reasons), and keep the palette simple. In the Chart Settings pane, select a color theme that matches your report or organization branding.

Resize and Reposition

In Layout View, drag the chart’s handles to resize it. You want the chart large enough that axis labels and data labels are clearly legible without zooming in. A chart that is too small defeats the purpose of adding it.

Link the Chart to Report Filters (Modern Charts Only)

One of the most powerful features of modern charts in Access is that they can respond to your report’s filter selections. In the Chart Settings pane, look for the Filter option. When enabled, changing a filter on the report updates the chart values automatically. This turns a static chart into a dynamic decision-making tool.

Choosing the Right Chart Type for Your Data

Access gives you over a dozen chart types. Here is a quick guide to picking the right one:

Column or Bar — Use when comparing values across categories, such as sales by product, calls by region, or revenue by month. Column charts are vertical; bar charts are horizontal and work better when you have long category labels.

Line — Use when showing trends over time. A line chart is ideal for tracking metrics across weeks, months, or quarters.

Pie or Doughnut — Use when showing proportions of a whole. Best with five or fewer categories. Avoid pie charts when categories have similar values, as slices become hard to distinguish.

Area — Use like a line chart, but with the area under the line filled in. Useful when you want to emphasize volume over time, especially with multiple series.

Scatter — Use when comparing two numeric variables to find correlations. Well suited for scientific, financial, or engineering data with many data points.

Combo — Use when you want to combine two chart types on the same axis, such as a column chart for volume and a line chart for a trend rate overlay.

Funnel — Use for showing a process with sequential drop-off, such as a pipeline or conversion flow.

Binding a Chart to a Query for Better Control

The cleanest way to add a chart to any Access report is to base it on a query rather than a raw table. A query lets you pre-aggregate, filter, sort, and shape the data before it reaches the chart, giving you full control over what gets plotted.

For example, instead of pointing a chart directly at a sales transactions table with thousands of rows, create a totals query that groups sales by month and sums the revenue. Then bind the chart to that query. This keeps the chart fast, clean, and easy to maintain.

To build a query for your chart, go to the Create tab, click Query Design, add your table, select your fields, and use the Totals button (the sigma symbol) in the Design tab to apply grouping and aggregation. Save the query with a descriptive name, then reference it when setting your chart’s data source.

Common Mistakes to Avoid

Choosing the wrong chart type for the data. A pie chart with fifteen slices is unreadable. A line chart that uses non-time-based categories creates a misleading impression of progression. Match the chart type to the nature of your data.

Skipping axis labels. A chart without labeled axes forces the reader to guess what they are looking at. Always label both axes with clear, human-readable names.

Overlapping text in small charts. If your chart is too small, category labels will overlap or get truncated. Resize your chart in Layout View until all labels display clearly.

Not testing in Print Preview. Layout View shows you the chart on screen, but Print Preview shows you exactly how it will appear when printed or exported. Always check Print Preview before finalizing a report that includes charts.

Forgetting to save the report. Access does not auto-save. After adding and formatting your chart, press Ctrl+S to save the report before closing Design View.

Exporting Reports with Charts

Once your chart is embedded in your Access report, you can export the entire report — charts included — in several formats.

Go to the External Data tab in the Ribbon. From the Export group, choose your target format: PDF or XPS, Word (RTF), HTML, or Snapshot. For most sharing purposes, PDF is the best choice because it preserves your chart formatting, colors, and layout exactly as they appear in Access, regardless of what software the recipient uses.

To export as PDF, click PDF or XPS, choose a save location, confirm the file name, and click Publish. Your report with all embedded charts will export as a single, shareable document.