- The layout of a PivotChart is different in Excel than in Access (a discrepancy Microsoft
should clear up, but that is another matter). The fields from the query are listed in the
PivotTable Field List in the panel on the right of the worksheet; I dragged OrderQuarter
to the Axis Fields drop zone, CategoryName to the Legend Fields drop zone, and Price to
the Values drop zone (Excel automatically makes it a Sum of Price). Figure 12.13 shows
the plainly formatted PivotChart at this point.
FIGURE 12.13
An Excel PivotChart with fields assigned to drop zones.- To format the left axis number, right-click any category value in the PivotChart and select
“Format Axis” from the context menu, as shown in Figure 12.14.
Going Beyond the Basics 12