Inserting an extended pie chart

Extended pie charts allow you to roll up data across one or more columns in a result set.

1. Double-click the Pie Chart object in the Layouts palette of the Palette view.
   The Pie Chart Wizard opens.
2. In the All Data Sources tree, navigate to the table or query that will be run to obtain the layout object's query result set and click Next.
   The Select layout type page opens.
3. Click Extended and click Next.
   The Select one or more fields to be moved in the side group page opens.
4. Select one or more columns in the Available fields list box and click Move Right to move them to the Fields to be moved list box.
   The columns that you move to the Fields to be moved list box will be rolled up in the query result set, and the order of the columns will determine the roll up hierarchy.
5. Click Next.
   The Select options for the pie chart page opens.
6. In the Wedge values drop-down list, specify the name of the column of data in your query result set that will contain the values for each pie wedge in the pie chart.
   You must select a data column from the drop-down list of available data columns in your query result set.
7. In the Aggregation drop-down list, specify how the column of data specified in the Wedge values field will be aggregated.
8. Select the Include a label for the wedge check box to include a label for each wedge.
9. In the Label field drop-down list, specify the data column in your query result set that will contain the label information for each pie wedge.
   You must select a field from the drop-down list of available data columns from you query result set if you selected the Include a label for the wedge check box.
10. Select the Include the value of the wedge check box to display in the pie chart the value of each wedge.
11. Select the Include the percentage the value represents of the whole pie check box to display a percentage value for each pie wedge.
12. Click Finish.
    The Pie Chart Wizard closes and the chart is displayed in the editor window.