MS Access for the Business Environment: Create a PivotChart View in Access - Page 8
August 4, 2003
Now let's perform a few formatting and organization steps.
The Properties dialog appears, defaulted to the General tab, as shown in Illustration 25.
Click for larger image
The Format tab - Properties dialog appears as depicted in Illustration 26.
The Format tab - Properties dialog appears as depicted in Illustration 27.
The Properties dialog appears, defaulted to the General tab.
Our PivotChart appears, after our enhancements, as shown in Illustration 29.
To conclude our exploration of the PivotChart, let's practice changing the view of the data.
The City selection drops down.
All cities become deselected.
The selector dropdown closes.
The Properties dialog appears.
The PivotChart appears, with our modifications, as depicted in Illustration 31.
There are numerous other options and views we might select within our PivotChart to customize it for the myriad analysis requirements that we might encounter. The addition of the PivotChart to Access 2002 provides a great analysis and presentation tool to business analysts and other information consumers everywhere.
With this lesson we introduced the PivotChart in MS Access 2002, basing it upon a PivotTable view we created for that purpose. After a brief introduction to PivotChart views, and a comparison to the PivotTable views we explored in the previous lesson, we began to explore some of the ways that we can use the PivotChart for interactive data analysis. In preparing to show the various steps in using the PivotChart, we first created a query, which in turn supported a PivotTable, both as a review of the steps we took in the previous lesson and as a means of creating the basis for the PivotChart. Once we created the PivotChart, we explored ways to organize the new PivotChart view to make it easy to use. We then took steps to format and organize our view, and walked through the process of changing the chart type, examining various formatting procedures as we proceeded.