PivotCharts ......................................................................................................
Making a PivotChart is even easier: select the data source query or table and click the PivotChart
button in the Forms group in the Create tab of the Ribbon. Figure 1.27 shows the new, blank
PivotChart with drop zones at the top and right sides of the form.FIGURE 1.27
A new, blank PivotChart.As with a PivotTable, you simply drag fields from the field list to the appropriate drop zones.
I dragged the OrderQuarter field to the Category field drop zone, the Supplier field to the Series
drop zone, the CategoryName to the Filter drop zone, and the Price field to the Data drop zone,
and I selected the Dairy Products category for filtering the data. Figure 1.28 shows the PivotChart
at this point.Part I The Office Components and What They Do Best