How to make Donut Chart in Tableau

Tableau is an exciting Business Intelligence Tool that always gives you more insights of your data. It is beautiful and elegance visualizations that makes you understand your business data. One of the custom charts is Donut chart, therefore lets have a look at it in details. It seems like a type of Pie Chart that has a hollow in the center.

Steps to create Donut chart

Step 1: Create a Pie chart

1. First of all connect to Superstore sample data in Tableau Desktop.

step1

2. Under Marks, select the Pie mark type.

step2

3. Drag Category to Color.

4. Drag Sales to Angle.

5. Click Label, and then select Show mark labels.

step5

6. Resize the pie chart as desired.

Consequently  we get this amazing Pie chart…..

step6b

Step 2: Switch to the dual-axis chart

1. Drag Number of Records to Rows.

2. Drag Number of Records to Rows again.

3. On Rows, right-click both instances of Number of Records, and then select Measure(Sum) > Minimum.

step2c

Finally this is what you get

step2cb

4. On Rows, right-click the second instance of Number of Records, and then select Dual Axis.

step2_4

Step 3: Change the second pie chart to a circle

1. First of all at the bottom of the Marks card, click MIN(Number of Records) (2).

2. Remove Category from Color.

3. Remove Sales from Angle.

step3_3

4. Click Color, and then choose the same color as the background. In this example, click white.

step3_4

5. Also to change the size click Size, and then drag the slider to the left due to which the circle becomes smaller.

6. Drag Sales to Label.

step3_6a

As a result you get the below chart!!

step3_6b

Step 4: Multiple Donut Charts in one view

1. Finally drag region into column and here we go with the multiple region Donut analysis of sales.

step4last
Multiple Donut Charts

Please share your comments below………….



mm
Author: Shivani Paliwal
Shivani has over 7 years of experience in project management and execution. She leads the BI and Data Analytics team at Actiknow and has expertise in industry leading BI Tools. She has extensive knowledge in implementing sales, marketing, operations and digital dashboards.

Leave a Reply