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.

Illustration 21: The Context Menu

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

Illustration 22: The Chart Properties Dialog, Type Tab

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

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

Illustration 23: Select the 3D Column Clustered Type

Our PivotChart appears, after our Type change, as shown in Illustration 24.

Illustration 24: PivotChart Reflects 3D Column Clustered Type

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.