Skip to main content
Version: 9.5

Pie Chart

A Pie Chart divides a circle into slices. The full circle, or “pie”, represents 100% of the data points selected. Each slice represents a different category proportional to the value it visualizes. Pie charts are best suited for showing the proportions of a small number of subcategories that make up a whole. For example, you can display proportions of Yes, No, and Impartial votes in a total vote count.

pie

Create a Pie Chart​

To create a Pie Chart, you need one column for Category and one for Values.

The following example visualizes the proportion of each product line across all orders.

  1. Drag and drop the productLine as Category and quantityOrdered as Values.
  2. In the Configuration Panel change the shape Type to Donut.

pie

For best results, limit pie charts to 10 slices or fewer.

Style the Pie Chart​

In the Configuration Panel on the right of the Chart Builder, you can style different aspects of your chart.

General​

The General section is available for all chart types, and the options vary depending on the chart selected.

Styles​

Use the Styles section to control visual elements such as colors and labels. This chart type supports the following specific options.

  • Theme - Select a theme to provide a more unified look of your charts.

  • Match colors across charts - Unify the colors of categorical values across all pages and applications where the same dataset categories are used.

  • Type - Select a Pie or Donut shape for the chart.

  • Data Labels - Enable or disable the display of Data Labels, which represent data values from the dataset column assigned to the Value shelf.

    • Multiline Labels - When Data Labels have been enabled, display the label text on multiple lines within the available space on the chart.

  • Pie Size - Select a size for the chart (Small, Medium, Large).

  • Values - When checked, display the data fields as Values or Percentages. Use the Format section to set the format of the values:

    • Default (numeric)

    • Abbreviated

    • Decimal (set the number of decimal points)

    • Currency (select the currency from the drop-down menu and set the number of decimal points)

    • Percentage (set the number of decimal points)

    • Scientific

    • Duration

      You can also set the format using the options menu in the Values column pill.

  • Percentages - When checked, display the percentage of the corresponding segment.

    • Force percentages total to 100 - Check this box when the sum of percentages in the chart is less than 100%. The difference between 100 and the sum will be applied to the largest chart segment. If all chart segments are equal, the difference will be applied to any of them. For example, to get the chart with the following percentages, 33%, 33%, 33%, to 100%, 1% will be added to one of the segments to get the sum to 100% resulting in 33%, 33%, 34%.

  • Offset - By default, the system centers the chart within the layout (Auto). To create a manual offset, select Percentage or Pixels, then add numbers to the Left and Top fields.

Sorting​

You can sort by either the category or aggregated values from the column pills. If the column is not included in the chart, go to the Sorting section of the Configuration Panel and select the column from the dropdown, then select the sorting direction. For more information, see Sorting.

Format​

You can apply conditional formatting to your Pie Chart.

Filters​

You can also add Filters to your data by expanding the Filters section in the configuration panel or by selecting Filters from the toolbar above the canvas. Filters that are created in the Chart Builder are hidden from end users. You cannot edit or interact with these filters in view mode.