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.

1. Right-click the chart we have created, in any blank area.

A context menu appears, as shown in Illustration 21.

2. Click the Chart Type option that appears in the context menu.

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).

3. Select the 3D Column Clustered type (the second option in the middle row of columnar types).

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.