Part IV: Managing and Analyzing Data
FIGURE 30.25
This data will be used to create a PivotChart.Figure 30.26 shows a PivotTable created from this data. The Date field is in the Rows area,
and the daily dates have been grouped into months. The Region field is in the Columns
area. The Sales field is in the Values area.FIGURE 30.26
This PivotTable summarizes sales by region and by month.