Formatting and Organizing the
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.
- 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
- Click the Chart Type option that appears in the
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).
- 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
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
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.