Pie Chart
Overview
Pie charts represent the percentage of the whole for each Category included in the chart. Pie charts are a good choice when there are a smaller number of categories represented, which keeps the pie chart slices large enough so a user can discern the differences between the pie slices.
A pie chart requires a Value and a Category type column to create a chart as shown in the example below.
Example
SQL:
SELECT AMOUNT, SOLD_ON as MONTH, ITEM
FROM ITEM_SALES
where YEAR(SOLD_ON) = 2019
Now you will prepare your result set as shown in Data Preparation so that we have the SOLD_ON (MONTH) column sort as a month of the year.
Click the create a chart button to display the Create Chart dialog. Now you will select the appropriate columns to use for the chart. In this example the value will be amount and the category will be month.
Chart Specific Options
Option | Description |
3D | Creates a chart with a 3D appearance. |
After clicking Create Chart, the pie chart will be displayed. Note that the month names are displayed in order. This occurs because we sorted the result set by MONTH before creating the chart.