Strategy: There have been many pivot table examples in the book. It is also possible to make a chart that relies on a pivot table.
Select a single cell in your data and choose Data – PivotTable and PivotChart. In Step 1 of the Wizard, change the last option button to create a pivot chart, as shown in Fig. 995. Hit Next.
Confirm the data range in Step 2. Choose Next, as shown in Fig. 996.
In Step 3, choose Finish, as shown in Fig. 997.
You will be presented with a blank pivot chart, as shown in Fig. 998.
- Drag the Revenue field from the Field list and drop it in the main part of the
chart, as shown in Fig. 999.
Drag the Date field and drop it in the Category Fields area, as shown in Fig. 1000.
Drag the Product field and drop it in the blue box near the legend on the right side of the chart, as shown in Fig. 1001.
Drag the Region field and drop it in the Page Fields area.
Result: As shown in Fig. 1002, you can change the Region field to quickly produce a chart for each region.
Summary: You can use a pivot chart to create charts for several different regions.