How to create donut chart in Tableau
Updated on 10th May, 22 466 Views

Over time, we have come across various data visualization styles and tools. However, as many tools were there, there were also significant downsides to them. For example, if we are comparing sales of different departments of an organization, using all the previous tools we could get to know which department is leading the race, but wouldn’t be able to know the whole amount of sales. So, this is the point where the Donut chart comes into action.

In this blog, let’s see how to create a Donut Chart in Tableau. The following is a list of topics that will be covered in this blog on Donut Chart in Tableau.

Check out this video to know about how to become a Tableau certified professional

Introduction to Donut chart

A donut chart is an alternate form of the pie chart. But, unlike pie charts, it has an area of the center cut out and displays attributes or categories as arcs. Pie charts try to show the proportional values of the attributes to one another and to the chart as a whole. This point makes it difficult to compare various pie charts. A donut chart rectifies this situation by de-emphasizing the use of the area. It helps readers to focus on the length of the arcs rather than the proportions. Donut charts are also more space-efficient because the blank space inside them can be used to display information inside them. 

Donut chart

Not sure about the concepts of Tableau. Check out this blog on Tableau for Beginners to get started with the concepts of Tableau.

Creating a Donut chart in Tableau

A donut chart is a union of two things. The first one is the regular pie chart and the other is just a whole circle. Following are the steps that needed to be implemented to create a Donut chart in Tableau. In this blog, we are going to work with the sample dataset available in Tableau.

  1. On the home screen of the Tableau Desktop, Under the Saved Data sources card, click on Sample-Superstore.

2. Drag the category to the “colors” card in “Marks”.

3. In the “Marks” card change the drop-down box value to pie.

donut chart step-1

4. Drag the quantity to the “Angle” card in the “Marks”.

Donut chart step-2

5. Now the pie chart part of the donut chart is ready and we are yet to make another circle. For that, we need to write avg(0) in the “Rows” shelf as shown in the figure.

row shelf of tableau

6. After this step we will be having two pie charts and using the “size” in the “marks” card the size of the first pie chart should be increased.

7. For the lower pie chart need not be a pie chart so we remove the category field from the “Marks” card of the second chart.

donut chart

8. Following the previous step we need to right-click on the axis and select “Dual Axis”. Then, synchronize both of them.

donut chart in process

10. Drag sales to the “angle” field of both the pie charts. Change the color of the second chart to white by clicking on the color field. Finally, we have our much-awaited donut chart here.

Donut chart
Become a Business Intelligence Architect

There are different variations of the donut charts. Some of them are as follows:

  • Stacked Donut chart
  • Concentric Donut chart
  • Donut Pie chart
  • Half Donut chart
  • Multiple Donut chart
  • Double Donut chart

Let’s see how these various donut charts are implemented in Tableau.

Stacked Donut Chart in Tableau

In this chart, as the name suggests we stack pie charts on one another to compare different measures.

1. Fill the column field as INDEX() and change the “automatic” in the “Marks” card to pie.

column shelf of tableau

2. Drop the “Measure names” to the “filter” card and select the necessary attributes required to create the stacked donut chart.

Filter feature of Tableau

3. Drag and drop the “Measure Values”, “segment” to the “details” field, and “Measure names” to the “color” field of the “Marks” card respectively.

4. Now click on the drop-down option of the index in columns field and opt for compute using segments.

Index method in column

5. Drag the Index()(+ctrl) from the columns field to the “size” field of the “Marks” card. Based on the index value it would allot the size to the pie chart. Now, we move forward to stack all these charts on one another.

6. Divide the index by a large number, say 100,000 to adjust the range.

Index calculation
stacked donut chart

7. By right-clicking the axis, opt for the edit axis option and change the options to fixed and write the range between -2 to 3 in order to stack all of them up.

edit axis

8. Add another field to the column that is SUM(0) and then go for the dual-axis to add both the pie charts.

Stacked Donut chart process

9. Now, increase the size of the first chart i.e., INDEX()/100000, and decrease the size of the last added chart respectively. Remove all the details and color attributes from the last pie chart. 

Stacked Donut chart in process

10. By adding the labels in the respective cards of the two charts we would get the stacked donut chart.

Final Stacked donut chart
Master Data Visualization Using Tableau

Donut Chart For Multiple Measures

In this context, we create a donut chart for multiple measures. The steps to be followed to create this chart are as follows.

1. Create a Pie chart for multiple measures by dragging and dropping Measure Names and Measure Values to the fields of “color” and “angle” respectively. 

2. From different types of filters apply the filter to Measure Names by dropping it in the “Filter” card and selecting desired measures. In this example, we have selected ‘sales’, ‘quantity’, and ‘profit’.

Donut chart for multiple measures

3. Now, to create another copy of the pie chart we write SUM(0) to duplicate the chart.

4. Now, by repeating the process mentioned in the section of the Donut chart we get to create a Donut chart for Multiple measures.

In process multiple measures donut chart

Multiple Donut Chart in Tableau

Multiple Donut charts are useful to show proportional parts of multiple wholes with different segments as columns.

Continuing the process of the donut chart with multiple measures, we should add “Segment” to the columns field. By doing such we get multiple donut charts as below.

column and Row field of Tableau
Donut chart for multiple measures.

Half Donut Chart in Tableau

  1. Create two pie charts and follow the steps of creating a donut chart.
  2. After the donut chart is made, change the colors of measures or attributes that are contributing to half of the chart to white. This will make only half of the chart be displayed thus, making it a half donut chart.
Half Donut Chart in Tableau

Want to know How to Create Stacked Bar Chart in Tableau!

Double Donut Chart in Tableau

1. Create two sheets and create two donut charts in each sheet as mentioned above.

2. Now, click on Dashboard >> new Dashboard.

3. In the Dashboard drag and drop both the sheets. In the settings make one sheet floating and place one donut inside another donut chart and remove the borders in the settings.

Double Donut Chart in Tableau.

 Below is the double donut chart which will be created.

Double donut chart

Donut Pie Chart in Tableau

1. Create two sheets with a pie chart and a donut chart in each of them.

2. On the dashboard, merge these two sheets. 

3. The settings of the one with the pie chart should be marked as floating so that we can place it in the middle of the donut chart of the other.

4. By doing this, below is the image of the donut pie chart in Tableau.

Donut Pie Chart

Concentric Donut Chart in Tableau

The Concentric Donut chart is also known as the Sunburst chart or Multi-level chart. The following are the steps to be followed to create a concentric donut chart.

  1. Create two pie charts in the sheets with different measures as mentioned before and select a dual-axis to stack them up.
  2. In this example, we add both category and subcategory to the color field and sales to the angle field. Here, we are adding two measures to the color field in order to align them with each other.
  3. Right-click on the subcategory and sort the colors according to the sales in ascending order.
concentric donut chart
  1. After labeling them, the concentric donut chart in Tableau is created.
concentric donut chart final

Tableau donut chart percentage 

To represent values in the donut chart as a percentage of the total, add the measure to the “detail” field of the “marks” card and right-click on it, opt for the Percentage of the total in the quick calculation. Now, add this measure to the “label” field. Now the labels would be the percentage of the total of that particular measure.

Conclusion

Tableau is one of the most popular Data visualization and Business Intelligence tools, used by various organizations around the world. The data visualization made it easy to compare various statistics using numerous variations of donut charts, pie charts, and bar charts. Donut charts have made the whole to part relationships in the data much easier for the users to analyze and interpret.

Check out our Business Intelligence Community for more information about Tableau.

Course Schedule

Name Date
Power BI Training 2022-11-26 2022-11-27
(Sat-Sun) Weekend batch
View Details
Power BI Training 2022-12-03 2022-12-04
(Sat-Sun) Weekend batch
View Details
Power BI Training 2022-12-10 2022-12-11
(Sat-Sun) Weekend batch
View Details

Leave a Reply

Your email address will not be published. Required fields are marked *

Speak to our course Advisor Now !

Related Articles

Subscribe to our newsletter

Signup for our weekly newsletter to get the latest news, updates and amazing offers delivered directly in your inbox.