Donut chart adds aesthetics when compared to a pie chart. However, as you may know, we cannot create a Donut chart with the help of charts in the "Show me" section.
We need to do a few things out of the box to create a donut chart. To create one,
follow the steps below:
First create a pie chart. To create a pie chart, you need at least one measure and one dimension. Here, in this super store dataset, I have used "profits" measure and "Region" dimension to create a pie chart. Add "Profit" to Rows and "Region" to columns. In the show me section, choose pie chart.
2. We need to duplicate the pie chart. For that, we need to add a place holder, so that we have 2 different pie charts and 2 marks card. Double click in rows section 2 types and type min(1) in rows 2 times as shown below:
The output will be as below:
3. In the 2nd AGG(Min) card, remove the Region from colors and Profit from Size:
4. You should see a gray color circle in 2nd row. Click on the "size" icon in the 2nd Agg(min) card and slightly reduce the size.
5. Right click the secondary size and click on dual axis:
6. Now you should see a donut chart with gray circle in the Centre. To make it white, click on the 2nd Agg(min(1)) and change the color to white. Now you should see fully completed Donut chart.
7. Format the donut chart by adding "Region" and "Profit" to label in 1st marks card.
8. To add readability, you can click on "quick table calculation" in the drop down of below image (in first agg(min(1))) and select "percent of total"
9. Your Donut chart is ready!!!
(got queries? mail to araviswami@gmail.com)
Comments