Home Learners Novice Tableau QT: Doughnut Charts

Tableau QT: Doughnut Charts

0
1479

This is a Quick Tip on how to build doughnut charts in Tableau, so less reading and more jumping in. We are going to spend 5 minutes or less building our doughnuts charts.

Data

Load the following data into Tableau Desktop / Public.

SliceValue
A100
B70
C50

Worksheet

  • Create a Calculated Field called Inner with the following value: 0
  • Create a Calculated Field called Outer with the following value: 0
  • Drag Outer onto Columns
  • Drag Inner onto Columns
  • Right-click on the second Inner pill and select Dual Axis.
  • In Marks activate SUM(Outer)
    • Change the Mark Type to Pie 
    • Drag Slice onto the Color
    • Drag Value onto Size
    • Click on Size and move the needle to the middle 
    • Drag Value onto Label
      • Right-click on the Sum(Value), select Quick Table Calculation, select Percent of Total
  • In Marks activate the SUM(Inner)
    • Remove the Measure Names from Color
    • Click on Color and set the Color to White
    • Drag Value onto Label
    • Click on Label and set Alignment to Center

Now we need to adjust the basic cosmetics:

  • Remove Gridlines and Zero lines
  • Hide Headers
  • Give the Outer Pie Chart white borders
  • Edit the Tooltips
  • Edit Labels

and boom, you should get the following:

You can experiment with different cosmetics, labels and tooltips.

Summary

I hope you all enjoyed this article as much as I enjoyed writing it. Do let me know if you experienced any issues recreating this Visualisation, and as always, please leave a comment below or reach out to me on Twitter @Tableau_Magic.

If you like our work, do consider supporting us on Patreon, and for supporting us, we will give you early access to tutorials, exclusive videos, as well as access to current and future courses on Udemy:

Also, do be sure to check out our various courses:

NO COMMENTS

Leave a Reply

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

Subscribe to our mailing list to keep up to date.