Likewise, right-clicking on
the legend and choosing Format Legend allows for customizations to the chart legend.
The PivotChart is live, meaning that users can expand values to see lower levels of
detail. This can be done within the chart by double-clicking on a bar or pie slice or data
point, depending on the chart type. For example, if the user double-clicks on a bar on
the PivotChart shown in Figure 9-16, the chart expands to show the data for the two
semesters of each year. In other words, double-clicking on a bar drills the user down
on the dimension shown in the Legend Fields. The PivotTable updates to show the
semesters as well, but the chart also continues to show the year values. Fortunately, the
PivotChart is smart enough to show only the lowest level of detail currently available,
rather than showing both the years and semesters at the same time.
Figure 9-16 A PivotChart is added to the same worksheet as a PivotTable. The two use the
same Field List because the PivotChart was created from the PivotTable.
C h a p t e r 9 : A n a l y s i s w i t h E x c e l 2 0 0 7 315
Instead of double-clicking on a bar, the user can also double-click on a member
in the legend, which has the same effect as double-clicking on a bar. Likewise, the
user can double-click on a value along the X axis to drill down on the dimension on
the Axis Fields. Double-clicking on any of the members shown on the X axis will
expand to the subcategory level.
Sometimes having the PivotTable and PivotChart on the same page is too
restrictive due to a lack of screen real estate.
Pages:
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403