Microsoft Office Tutorials and References
In Depth Information
Chapter 27: Data Mining Using Pivot Tables
FIGURE 27.10 Grouping the Data
FIGURE 27.11 Grouped Data
Date. You are faced with the same problem: too much information. See Figure 27.12
for the results.
The solution, again, is to group the data. This time the grouping should be
different: Right-click and select Group. The menu
recognizing the fact that you are
will suggest time-related grouping categories. The Grouping menu
allows you to choose dates. I chose months. See Figure 27.13.
The results are shown in Figure 27.14. Remember the chart is being updated in
the background. Sales look slightly higher for June, July, November, and December.