Inserting a pie chart using a relational query

Pie charts display data in a circular chart that is cut into wedges.

About this task

To insert a pie chart using a relational query:

Procedure

  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 relational 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 Standard and click Next.
    The Select options for the pie chart page opens.
  4. 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.
  5. Select the Include a label for the wedge check box to include a label for each wedge.
  6. 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.
  7. Select the Include the value of the wedge check box to display in the pie chart the value of each wedge.
  8. Select the Include the percentage the value represents of the whole pie check box to display a percentage value for each pie wedge.
  9. Click Finish.
    The Pie Chart Wizard closes and the chart is displayed in the editor window.