tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Access: Create a graph (ie: chart report) in Access 2003/XP/2000/97

Question: In Microsoft Access 2003/XP/2000/97, is it possible to create a graph?

Answer: Yes, in Access you can create a graph. This is called a Chart report.

Let's walk through an example.

Open your Access database and click on the Reports tab in the Database window.

Microsoft Access

Click on the New button.

Microsoft Access

When the New Report window appears, highlight Chart Wizard. Then select the query/table that you wish to use to create the graph. In this example, we've chosen the OrderDetails. Click on the OK button.

Microsoft Access

Select the fields that you want to use in the graph. We've selected the OrderDate and Total Order fields. Click on the Next button.

Microsoft Access

Select the type of graph that you'd like displayed. Click on the Next button.

Microsoft Access

Customize the layout of the graph. In this example, the Chart Wizard has chosen "OrderDate by month" for the x-axis of the graph. We want to see the date by year. To change this, double-click on the "OrderDate by month" button.

Microsoft Access

When the Group window appears, we've highlighted the Year value since we wish to see the graph summarized by year (not month). Next, click on the OK button.

Microsoft Access

Now when we return to the Chart Wizard, the x-axis label displays "OrderDate by year". Click on the Next button.

Microsoft Access

Next, select a title for the graph. Click on the Finish button.

Microsoft Access

Now when we view the report, we should see the graph that we've just created.