A “Chart”

We can insert a “Chart” in an existing “Form” or “Report”.
In this example, I have a “Products” form, which I opened in “Design View”.
The first thing you do is to make some room for your “Chart” in the “Details” section.

To add a “Chart”, click the “Insert Chart” button under the “Design” tab in the “Ribbon”.
Click and drag in the form, to the place where you’d like to insert.

This opens the “Chart Wizard”.
In the first wizard window, choose a “Table” or “Query” that you want to make a “Chart” for.
I choose the “Orders” table. This is also the table where I have entered all goods sold.

Click the “Next” button.

In the second window of the wizard, you define the data you want to use in your “Chart”.
In this case it is the “Date” field and the “Quantity” field.
The purpose of my “Chart” is that I get a clear picture of the number of each article sold.

Click “Next”.
In the third window you determine the type of “Chart”.
When you select a “Chart” on the left of the window, you get a description of these on the right side of the window.
I choose “Column” chart and click the “Next” button.

In the fourth window, we determine how we want to classify the data in our “Chart”.
“Access” will give you a suggestion but, you can always change it by dragging the field buttons and placing them in the different compartments of the sample “Chart”.

You can also change the value of the fields in the example “Chart”, by double-clicking them.
For example, if you double-click on the “Date of Month” in the example “Chart”, the “Group” window appears where, you have the choice to group the data by year, quarter, month, etc.

So for example, if you double-click on the “SumofAmount” in the example chart, the “Summarize” window appears where, you have the choice to summarize the data by Sum, Average, Minimum etc.

Click the “Next” button to continue.

In the fifth window, select the field in the form and the field in the “Chart” that must be linked with each other.  In other words, when you navigate between the various articles, the “Chart” should also be adjusted.  “Access” will give you a suggestion here too.

Click the “Next” button.

In the last window of the wizard, we enter a title, which is shown above the chart.
And you make a choice whether or not you want to display a legend in your chart.
Click the “Finish” button.

Save your report, and go to “Report View” to see the result.
Use the navigation buttons to navigate between different charts for sold articles.

Featured Courses

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