Datasheet

Figure 1-13: The PivotChart breaks the data down by store and by category.
Figure 1-14: Selecting which Category fields to include in the chart.
Creating a PivotChart
A PivotChart is nothing more than a standard Excel chart created from the data in a
PivotTable report. In fact there are a few features in PivotCharts that you will not find in
charts based on other data — that is, data not in a PivotTable. For the most part, however,
a PivotChart is like any other Excel chart and can be manipulated and formatted in the
same way. The few differences will be covered as they come up.
Part I: Understanding PivotTables and Charts
12
03_772402 ch01.qxd 11/30/05 9:41 PM Page 12