Tableau Charts: Doughnut chart

February 19, 2018

The series, Tableau charts has always focused on one thing, helping Tableau users learn how to create different charts and graphs hence equipping them with different techniques of telling each data story. Therefore, inspired by the mission of this series, we’ll explore on how to create a doughnut chart in Tableau.

Using Superstores data set pre-packaged with Tableau app. We'll visualize Profitability within various 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 achieve our goal.

Lets do it.

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

  • 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.

See the resulting chart.

 Making the Pie Charts dual.

 Executing above we've.

 

Synchronize the axis.

 

 Doing some formatting to eliminate lines, and hide the text measure holder.

 Chose the First Pie, and,..

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

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

 Choose the Second Pie, and,..

  • Resize the Second Pie by minimizing its Size.

  • Change the color from default to 'White'.

 

 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 tab.

 

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.

Thanks for reading.

 

Share on Facebook
Share on Twitter
Please reload

Featured Posts
Please reload

YOU MIGHT ALSO LIKE
Please reload