Tutorial: How to create a donut chart in Tableau Software?

donut chart

In this article, we will create a very popular chart in Tableau : the donut,doughnut, or ring chart.

A doughnut chart is a pie chart with an additional ring around the outside. A pie chart shows the contribution of each amount (such as a proportion or sales figures) to the total amount (such as annual sales).

The advantage of this type of chart is that it allows you to include additional information about the underlying data (in the middle, for example).

However, be careful to use this type of chart wisely. It is appropriate to use it if:

  • you compare a few general elements or determine the importance of one of them in relation to the others;
  • you want to present key performance indicators (as a percentage of the total).

If you want to use it for another scenario, this chart would not be the best choice for understanding your data.

 

How do I create a donut chart in Tableau?

 

The secret is to use two pie charts. In this example, we show the distribution of online orders (Proportion) by type of device (Purchase online) for a store.

 

donut

1. Créer un graphique à secteurs (« camembert »)

  • In Tableau Desktop, connect your data.
  • UnderMarks, select Pie Chart as the mark type.
  • DragPurchase onlinetoColor and Labels.
  • The same applies toProportion toSize.

donut3

  • ClickLabel, then selectShow Guide Labels.
  • Resize the pie chart as desired.

You should have a graph similar to this one:

 

2. Switch to dual axle

  • DragNumber of RecordsontoRows.
  • DragNumber of Recordsback toRows.
  • InLines, right-click on the two instances ofNumber of Records, then selectMeasure(Sum)>Minimum.

donut4

  • InLines, right-click on the second instance ofNumber of Records, then selectDouble Axis.

donut5

 

3. Change the second chart to a pie chart.
  • At the bottom of theReference tab, clickMIN(Number of Records) (2).

donut6

  • Remove Purchase online fromColorandSizeRatio.
  • Remove the labels.
  • ClickColor,thenchoose the same color as the background. In this example, click White.

donut7

  • ClickSize, then drag the slider to the left to reduce the size of the circle.
  • Right-click on each axis, then deselectShow Header.

Your donut is ready to use!

Author Profile

Elisa TANG

Write a comment

This site uses Akismet to reduce spam. Learn more about how your comment data is processed.