• Bernard

Tableau Charts: Doughnut chart

Updated: Sep 3, 2020

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, this post will explore on how to create a doughnut chart in Tableau.

Using Superstores data set pre-packaged with Tableau app. I'll visualize Profitability within various product Segments.


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' (this color should always match the background of your view)

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.


Top 35 Data Visualization Widgets

Take your data visualization skills to the next level with this FREE guide!!

FREE Tableau Desktop Course for Beginners

Get started with Tableau, a data visualization tool that allows you connect to nearly any data and create interactive visualizations.