Pie Chart
Watch Video: Creating a Chart (Pie Chart)
This video might show an earlier version of the feature or operation that differs in minor ways from the current version.
A pie chart displays a single measure on a circular axis.
What is a measure?A measure is generally used for aggregation, for example summation, averaging, correlation, etc., within a Crosstab, Chart, Text component, or Gauge. Adding a measure to the ‘Y’ region in a chart displays the computed aggregates by using locations on the Y-axis. Adding a measure to the ‘X’ region displays the computed aggregates by using locations on the X-axis. You can also display aggregates by using color, shape, size, or label. |

To create a pie chart, follow the steps below.
|
If you are new to charting, see the following sections first: Configure Your Data…The data source for the chart (data block or data model) should represent dimensions and measures as independent columns or fields, as shown below. See Prepare Your Data for information on how to manipulate your data, if it is not currently in this form. (Note: A properly designed data model will already have the correct structure.)
In some cases (e.g., Pie Chart), you may want your data to provide just a single measure. In other cases (e.g., Line Chart), you may want the data to supply multiple measures. If the data does not provide the correct number of measures, you may be able to alter the number of measures to suit the needs of the chart by “pivoting” or “unpivoting” the data. See Pivot Data in Prepare Your Data for more information about this procedure. Open a Chart for Editing…Watch Video: Create a Chart (Open the Chart Editor)This video might show an earlier version of the feature or operation that differs in minor ways from the current version. Follow the steps below to get started with a new Chart. See Basic Charting Steps for more details.
|
-
In the Chart Editor, drag the measure field (e.g., ‘Total’) from the Data Source panel to the ‘Y’ region.

-
In the Chart Editor, drag the dimension field (e.g., ‘Date’) from the Data Source panel to the ‘Color’ region.
What is a dimension?
A dimension is used to break-down the dataset into multiple groups, often within a Crosstab, Chart, or Selection List. Adding a dimension to the ‘X’ region of a Chart distinguishes the different dimension groups by location on the X-axis. Adding a dimension to the ‘Y’ region distinguishes the different dimension groups by location on the Y-axis. You can add multiple dimensions into the ‘X’ or ‘Y’ regions of a Chart, or into the ‘Rows’ or ‘Columns’ regions of a Crosstab, to create multiple grouping levels. You can also distinguish groups in a dimension by using color, shape, size, or label in a Chart.

-
Press the ‘Edit Color’ button to choose the colors. See Group Data by Dimension for more information about the color panel.

-
Press the ‘Select Chart Style’ button , and choose ‘Pie’ or ‘3D Pie’. This converts the chart into a pie-chart representation.

-
Add the respective dimension values to the pie slices: Drag the dimension (‘Date’) field from the Data Source panel to the ‘Text’ region.

-
Optional: For a date dimension, press the ‘Edit Dimension’ button next to the field name in the Chart Editor, and set the ‘Level’ to the desired date grouping. Then press the ‘Apply’ button .
-
Optional: Remove the legend if desired. To do this, right-click on the legend, and select ‘Hide Legend’ from the context menu.

-
Optional: To place a small gap between the pie slices, follow these steps:
-
Right-click the plot area and select ‘Properties’ from the context menu.

-
In the Advanced tab of the ‘Chart Properties’ panel, select ‘Explode Pie’ and press OK.

-
-
Optional: You can add additional dimensions to the Chart if desired. See Trellis Chart (Grid) for information about adding multiple dimensions to a chart axis.
-
Press the ‘Finish’ button to close the Editor.
The pie chart is now complete.
+






