How Do I Create a Chart Report on Access 2007?

Access 2007 can create charts.

Access 2007 allows you to create reports in a chart format. These charts are exactly like the ones you can create in Microsoft Excel. By creating a chart report in Access 2007, you can view data in an easy to understand chart format versus the typical listing of records in most Access reports. Chart reports are created along with standard reports and display both a listing of data and a summarized chart.

Things You'll Need

• Microsoft Graph

Instructions

1. Open an existing Microsoft Access 2007 database.

2. Click "Reports" in the main database window.

3. Select the report you want to add a chart to and press "Design." If you do not already have a report created, create a base report by clicking "New" and selecting "Report Wizard." Follow the wizard prompts to create the report.

4. Go to the "Insert" menu and choose "Chart."

5. Click where you want to place the chart on your report.

6. Follow the wizard prompts to choose your record source, such as a table or query, the name of your chart and type of chart you want to create.

7. Press the "View" button and choose "Print Preview" to view current data in the chart.

Tips & Warnings

• Charts can be added to both forms and reports. When creating a new report, you can create a chart by using the "Chart Wizard" option in the "New Report" screen.

• The chart wizard is not available in Microsoft Access projects unless you have Microsoft Graph installed. If you have your original Microsoft Access or Microsoft Office disk, insert the disk and install the feature when prompted.

References

• Microsoft Office: Add a Chart to a Form or Report