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 313
While the PivotChart has the focus, a new window appears, called the PivotChart
Filter Pane. There are two drop-down fields labeled Axis Fields and Legend Fields.
Dropping down either list reveals the same menu as seen on the drop-down lists in
the PivotTable, as shown earlier in Figure 9-7, when the Row Labels drop-down list
was opened. In addition, the labels of the boxes in the Areas section of the Field List
have changed to Axis Fields and Legend Fields as well. These labels will change
depending on whether the focus is on the PivotTable or PivotChart. Figure 9-16
shows what the PivotChart looks like on the same page as the PivotTable, along with
the PivotChart Filter Pane.
Changing the chart type after the PivotChart has been created is as simple as
right-clicking on the chart and choosing Change Chart Type. This opens a dialog box
entitled Change Chart Type, but it is identical to the Insert Chart dialog box shown
in Figure 9-15. The chart can also be customized by right-clicking in a blank area
Figure 9-15 The Insert Chart dialog box shows the variety of chart types that can be used
by the PivotChart.
314 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
and choosing Format Chart Area. This allows for the customization of colors, border
styles, drop shadows, and more. Right-clicking on the bottom axis and choosing
Format Axis allows for many customizations to the axis.
Pages:
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402