Spotfire® User Guide

Creating a pie chart

A pie chart is a circle graph that is divided into sectors. It is used to compare values for different categories in your data on a relative basis. Each pie sector represents a specific category, and its size the category's contribution to the whole value, expressed as a percentage.

Procedure

  1. On the authoring bar, click Visualization types to open the flyout.
  2. Drag the Pie chart visualization type to the desired position on the analysis page.
    A suggestion of a pie chart is presented.
  3. On the Color axis (in the legend or in the visualization properties), select the column containing the categories that you want to present as pie sectors.
  4. On the Sector size axis, select the column containing the data that the sizes of the sectors should reflect.
  5. For the selected column on the Sector size axis, make sure that the aggregation type is set to Sum.

    Sum is by far the most common aggregation in pie charts. However, there might be cases when Count or UniqueCount could be useful aggregation types.

Example: A simple pie chart

The data table lists the sales of different fruits.
Example data table.
The pie chart below shows the different contributions of different fruit types to the total sales. Note the settings on the Color by and Sector size by axes.
Pie chart showing the contribution of different categories to the total sales.

Example: Trellised pies with Size by

If you split the visualization into multiple pies for different categories using trellising, you can also add a sizing per pie by selecting a categorical column on the Size by setting in the legend or in visualization properties panel (Pie size by in the visualization properties dialog or popover).

In this example, each pie shows the sum of sales for different types of, fruit, vegetable and spices (Sector size by=Sum([Sales])), but the size of each pie also shows that the total sum of sales is largest for the "Fruit" category, and smallest for the "Spices" category (Size by=Sum([Sales])).

For more information about the different scale configurations for the Size by axis, see Resizing markers.