How to Make A Donut Chart in Tableau

Donut in Tableau

Donut chart is not an out of the box visualization in Tableau. Actually, it does not the stringent specification for Tableau data visualization philosophy. However, it is similar to pie chart which divides the a circle in different sectors based on the value of their proportions. But, the difference between Pie and Doughnut chart is that in a doughnut chart there can be more than one data series added as rings to the chart. Learn Tableau A-Z for Data Science.

Summary:

This blog will detail how to make a  donut chart in Tableau using Sample-Superstore data.
To create a donut chart, we first need to know the dimension on which we want to segregate and measure to define the proportion. So, in this case the  “Category” can be used  as the dimension and “Sales” as the measure.
Following are the steps to create a doughnut chart in Tableau:

1. Connect to Sample-Superstore dataset: Open the Tableau Desktop and select the “Sample-Superstore” dataset

2. Go to Sheet1:

3. In the “Marks” card, select chart type as pie

4. Drag the “Category” field to “Color” and “Sales” measure to “Size” & “Label” marks card

5. Now, drag the “Number of Records” to “Rows” shelf

Put the number of records on the row shelf

6. Select the “Number of Records” field in “Rows” shelf and change the default aggregation from “Sum” to “Minimum”

step 6 in how to make a donut chart in tableau

7. Again, drag the “Number of Records” from the measures and put it on “Rows” shelf on right after the 1st “Number of Records”

The seventh step in the how to make a donut chart for Tabelau

8. Change the default aggregation from “Sum” to “Minimum” for 2nd copy of “Number of Records” also

9. Do a right-click on 2nd copy of “Number of Records” field and select “Dual Axis” option

Step 9 in how to make a donut chart in Tableau

10. In the next step, select the “Min(Number of Records) (2)” in “Marks” card and remove the following:
– “Category” from “Color”
– “Sales” from “Size” and “Label”

11. Again, select the “Min(Number of Records) (2)” in “Marks” card, reduce the size of the pie chart and then select the color of the pie chart same as the background color (“white” color in this case)

you will need to change the color of the internal circle to create a donut chart in Tableau

12. In the last step, do a right-click on each of the axis and de-select “Show-Header

13. This is how the donut chart will look like.

You will need to increase the size of the visualizations for donut chart in Tableau