Selecting data for a pie chart
Unlike other chart types, a pie chart can display only one value series. For example, a pie chart can show sales totals by product line, but it cannot show sales totals and profit totals by product line. This section shows examples of selecting and organizing data for pie charts. Each example shows the following items:
*
*
*
Example 1
The pie chart in Figure 8-38 shows sales by quarter.
Figure 8-38  
Figure 8-39 shows the table data that the pie chart uses.
Figure 8-39  
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-40  
Example 2
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-41  
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-42  
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.
Figure 8-43  
Unlike the previous pie chart example, the category series (quarter) values are not grouped. Instead, the value series data is grouped by the region column.
Example 3
The pie chart in Figure 8-44 shows the number of products in each product line.
Figure 8-44  
Figure 8-45 shows a sample of the table data that the pie chart uses. The actual data spans two pages.
Figure 8-45  
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.
Figure 8-46  

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2