MS Access for the Business Environment: Create a PivotChart View in Access - Page 7
August 4, 2003
Formatting and Organizing the PivotChart View
Next we will examine ways we can organize the new PivotTable view to make it easy to use. We will format and organize our view, then we will change the chart type; finally, we will examine general formatting and organization of the view.
A context menu appears, as shown in Illustration 21.
The PivotChart Properties dialog appears, defaulted to the Type tab, as shown in Illustration 22.
We note that the current chart is set to exhibit the Clustered Column style, according to the description at the bottom of the Type tab. We also note that we have numerous other choices, not only within the Columnar types (the options appear in the form of pictures in the right pane of the Type tab), but among other chart types that are different entirely (listed in the left pane of the Type tab).
The 3D Column Clustered type selection appears in Illustration 23.
Our PivotChart appears, after our Type change, as shown in Illustration 24.
NOTE: The exact appearance of results may vary, based upon the scale parameters that result from "compression" of the PivotChart display. The images that appear, for example, in my illustrations are often "squeezed" to accommodate the space available in the document.