Create a PivotChart View
Microsoft Access 2002 provides a robust new technique, the PivotChart
view, for online analysis. In addition, PivotCharts provide an excellent
option for including charts in our forms and reports: We can embed a form that
is open in PivotChart view as a subform in another form or report. Numerous
advantages exist in using PivotChart views over chart controls.
As we discussed in the introduction, numerous differences
exist between PivotTable and PivotChart views. Let's review the
steps together for converting our existing PivotTable view to a PivotChart
view, beginning where we left off with the PivotTable view in the last section.
- Select View ->
PivotChart View from the main menu.
The PivotChart view appears in its raw form, as shown in Illustration
We will remove some of the extraneous fields to demonstrate
the potential of refined views in using the PivotChart. Keep in mind that any
field we remove from the PivotChart remains available for selection in the same
chart; while the removed item no longer appears in the chart, all that is
required to resurrect the field is to call upon the Field List, which
resembles the Field List we have used in the PivotTable view above and
in our previous lesson.
- Select Company Name at the right of the PivotChart
(called the Series area).
- Press the DELETE key.
- Select Order Date at the bottom of the chart
(called the Categories area).
- Press the DELETE key.
We note that, although we have deleted the Company Name and
Order Date fields, from the Series and Categories areas
respectively, Company Name and Order Date continue to appear in
the Field List as a selection option.
- Click-select the Order Date by Month field in the Field
List, as depicted in Illustration 18.
Illustration 18: Select Order Date by Month in the Field
- Drag the Order Date by Month field to the Category
fields area (where a box labeled "Drop Category Fields Here" is
currently displayed), and drop within the boxed area.
The PivotChart assumes the attributes depicted in Illustration
Illustration 19: Select the Modified PivotTable View
- Click the Years label (down arrow) that has
appeared in the Category area of the chart.
- Uncheck Year 1996 to remove it from the chart.
- Expand Year 1997 by clicking the "+"
sign to its immediate left.
- Deselect Quarters 3 & 4 in 1997.
From an accounting perspective,
this makes the two years comparable, as Year 1998 only has two quarters
- Click OK.
The PivotChart appears as shown in Illustration 20.
Illustration 20: Quarters 1 & 2, 1997 and 1998
The PivotChart offers options for manipulating the data and
enhancing the appearance of the graph, changing the chart type, modifying the
axis lines and labels, and assorted other standard chart attributes. We will
further explore these in the next section, where we will organize and format the
view we have created.