Get Ready For Your Tableau Certification
  • Bernard

Tableau Charts: Doughnut chart

Updated: May 17


Donut chart in Tableau

Definition

Donut (also known as doughnut) chart, just like pie chart is used to show numerical proportions – parts to whole.

Example of a donut chart

example of donut chart in tableau

Donut chart best practices

  • Do not use donut chart for dimensions with more than three categories.

  • Avoid donut chart if goal is to help user make fine distinctions.

  • Always label the chart clearly

  • Provide additional details on the tooltips

Using Superstores data set pre-packaged with Tableau app. I will show you how to create a donut chart to visualize Profit for different product Segments.

Note;

Doughnut chart is simply a pie chart with a hole inside, and the technique behind this chart in Tableau is creating a dual Pie chart and then using color/size tricks to create one.

Step by step guide on how to create a donut chart in Tableau

  • Create a calculated field named 'Measure holder' as shown below.

tableau measure holder
  • Drag the above calculated field to the Columns shelf.

  • Choose Pie under marks card.

  • Hold down control key and drag SUM(Measure holder) to the Columns shelf next to itself (duplicate the view).

See the resulting chart.

duplicating view in tableau

Making the Pie Charts dual.

tableau dual pie charts

Executing above we've.

Synchronize the axis.

synchronizing axis in tableau

Format the view to eliminate lines, zero axis and hide the header 'Measure holder'.

tableau pie chart formatting

Chose the First Pie, and,..

  • Drag the measure field Profit to the Angle shelf under marks card.

  • Drag dimension field Segment to the Color shelf under the marks card.

add color to tableau pie chart

Choose the Second Pie, and,..

  • Resize the Second Pie by minimizing its Size.

  • Change the color from default to White' (this color should always match the background color of your view)

tableau make pie chart bigger

Changing the color of the second Pie (circle).

donut chart tableau

And there we've our doughnut chart, lets do some formatting and labeling on our chart.

This can be achieved by;

  • Dragging the dimension field Segment and the measure field Profit to the Label shelf of the first Pie (circle).

doughnut chart in tableau

From the resulting doughnut chart, it's clear the Consumer segment is the most profitable and Home Office segment is the least profitable.

I hope this article was helpful to you. To receive more of the Tableau tips and tricks, kindly join our mailing list by subscribing below.

Thank you for reading.

#charts

1.png
2.png