Using the PivotChart
Earlier in the chapter, Figure 9-3 showed that when the user creates a new report, she
can choose to create a PivotTable or a PivotTable and PivotChart. This is one way to
create a PivotChart. Another way is to be on a PivotTable and click on the Options
Figure 9-13 Conditional formatting can be applied to a range of cells. In this instance,
Data Bars have been added to the values in the PivotTable.
312 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
tab under the PivotTable Tools tab. This opens the Options ribbon, which contains a
button labeled PivotChart. This button opens the Insert Chart dialog box, shown in
Figure 9-15. The PivotChart contains a wide variety of chart templates including bar,
column, line, pie, and many others. Each template may include a number of different
styles, which are selected in the right pane of the Insert Chart dialog box. Figure 9-15
shows the selection of the 3-D Clustered Column chart.
After clicking the OK button, the PivotChart is added to the page. (It is not
terribly considerate about where it appears, often overlapping with the PivotTable.)
Fortunately, it can simply be dragged and moved anywhere on the spreadsheet.
Because this PivotChart was created from the PivotTable, it is tied to the same Field
List, and updates to the PivotTable, such as expanding or filtering, will affect the
PivotChart.
Figure 9-14 KPIs from Analysis Services cubes can be placed in PivotTable reports,
including the actual value, the goal, the status, and the trend.
Pages:
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401