MS Access for the Business Environment: Create a PivotChart View in Access - Page 6
August 4, 2003
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.
The PivotChart view appears in its raw form, as shown in Illustration 17.
Click for larger image
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.
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.
The PivotChart assumes the attributes depicted in Illustration 19.
From an accounting perspective, this makes the two years comparable, as Year 1998 only has two quarters recorded.
The PivotChart appears as shown in Illustration 20.
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.