“Graphs” with the “Graph Wizard”

With the “Microsoft Graph” application installed when you install Access, you can insert charts and/or edit “Reports.”

With the “Graph Wizard”, we can easily and quickly create “Graphs” that contain pictorial representation of data from “Tables” and “Queries”.

To start the “Graph Wizard”, we first select “Reports” object in the window, and click “New”.

In the “New Report” dialog, we choose “Chart Wizard” and we select a query from the dropdown menu:

And click OK.

In the next window we select the fields that we want to show in our chart.

… and click “Next”.

In the next window we choose the type of graph:

and click Next.

In the next window we can see the available fields on the right. Drag the fields we want to find in our “Graph” to the model on the left.

If we click the button at the top left corner, “Preview Chart”, we can view our chart.
Click “Next “.

Next, we give a name to our graph report , and can choose whether or not we want to show a legend.

Click Finish.

The “Graph” opens in “Preview”.

We click on the “Design View” button.

When we are in “Design View” double-clicking on our chart opens two windows, one with our “Graph”, and one which resembles an “Excel” document.

When we make changes, they will actually be made to our chart “Report”.

If you have finished your report, click “Save”, give it a name, and click OK.

Editing “Chart” Object

We can edit our charts that we have created with Access.
To do this we double click on the “Chart” in “Design View”.
This activates the “Microsoft Graph” program.
Our toolbar changes:

With this toolbar, we can edit each selected object until we are satisfied with the result.

With this button we can make our data appear on our “Chart” as percentages, values, labels, etc.,

Try everything but, it points to itself.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats