how to make a pie chart in excel with a hole

The steps below include detailed instructions and details for you to reproduce a similar result on your Tableau Desktop.

In this step-by-step guide, I will be looking at visualizing the proportion of the profit values for various product categories on a Donut Chart. Tableau Donut Charts – Step-by-Step Guide

They help to visualize the proportions of categorical data, with the size of a “piece” being relative to the proportion of a category. Data from different categories are put together in several different “pieces” or “slices” of the “Donut” and “Pie”. They are given the name of “Donut Charts” due to their donut-like appearance, in the form of a ring. What are Donut Charts?ĭonut charts are in many ways similar to Pie charts. With a few tweaks and modifications, we can turn our Pie Charts (which are available in Tableau) into Donut Charts that work in a similar manner. For a more detailed step-by-step guide, you can refer to my instructions below! Detailed Guide: Creating Tableau Donut ChartsĪs I’ve mentioned above, Donut Charts are not currently a feature available in Tableau. This is the reason why we have to create a custom donut chart from 2 pie charts. Do take note that Donut Charts are not available as an option in the “Show Me” feature of ready-made charts. There you have it, a brief introduction on how a donut chart effect can be achieved. The empty circle, or second donut, has to be resized and formatted such that the two circles are aligned.

The empty circle in a Donut chart is used to overlay the original pie chart to achieve a hole similar to that of a donut shape! Include 1 or more dimensions and 1 or 2 Measures

Create a regular Pie Chart with the data you want to plot with.

Here’s how to Create a Donut Chart in Tableau

How to make a pie chart in excel with a hole