Skip to main content Skip to complementary content

Pie chart and donut chart

The pie chart and the donut chart display the relation between values as well as the relation of a single value to the total. You can use a pie chart when you have a single data series with only positive values. You can use a donut chart when you have a single data series that includes negative values.

In the pie chart, the dimensions form sectors of the measure values. A pie chart can have one dimension and up to two measures. The first measure is used to determine the angle of each slice in the chart.

Sales per region in a pie chart.

Pie chart.

Optionally, a second measure can be used to determine the radius of each pie slice. This style of pie chart is also known as a rose chart.

Sales by product sub group in a pie chart with the average sales per invoice sales determining slice radius

Pie chart using radius measure.

In the pie presentation of the pie chart, negative values in the radius measure are not supported and will be excluded. Negative values in the radius measure are supported in the donut presentation and will point in towards the center of the pie chart.

Sales by product sub group in a pie chart with radius measure containing a comparison of sales from the previous year

Pie chart with radius measure containing negative values.

When to use it

The primary use of a pie chart is to compare a certain sector to the total. The pie chart is particularly useful when there are only two sectors, for example yes/no or queued/finished.

We do not recommend that you compare the results of two pie charts with each other.


The pie chart provides an instant understanding of proportions when few sectors are used as dimensions. When you use 10 sectors, or less, the pie chart keeps its visual efficiency.


It may be difficult to compare different sectors of a pie chart, especially a chart with many sectors.

The pie chart takes up a lot of space in relation to the values it visualizes.

Creating a pie chart or donut chart

You can create a pie or donut chart on the sheet you are editing.

  1. In a sheet, click to add a new visualization.
  2. Under Visualization, select Pie chart or Donut chart.
  3. Click Add and select a field or master dimension for the dimension.
  4. Click Add and select a field or master measure for the measure.

The following settings are used by default in pie and donut charts:

  • The top 10 sectors are presented in descending size order, clockwise.
  • Colors are presented by dimension.
  • Value labels are presented in percent.

After you have created the pie chart, you may want to add a radius measure or adjust its appearance and other settings in the properties panel.

Related learning:

Learn more