Figure 8-39 shows the table data that the pie chart uses.
Figure 8-40 shows how the data is selected for the chart. The Quarter column is the category series, and the Sales column is the value series. In addition, the data is grouped by quarter, and the Sum function calculates the grand total of the sales, across regions, for each quarter.
Figure 8-41 shows a series of pie charts. Each pie chart shows the sales by quarter for a particular region, such as the United States, Europe, and Asia.
Figure 8-42 shows the table data that the series of pie charts use. It is the same set of data used in the previous pie chart example.
Figure 8-43 shows how the data is selected for the chart. The Quarter column is the category series and the Sales column is the value series.
The pie chart in Figure 8-44 shows the number of products in each product line.
Figure 8-45 shows a sample of the table data that the pie chart uses. The actual data spans two pages.
Figure 8-46 shows how the data is selected for the chart. The PRODUCTLINE column is the category series, and the PRODUCTNAME column is the value series. In addition, the data is grouped by product line, and the Count function counts the number of products in each product line.