Table of Contents
Creating a double doughnut chart in Excel involves using the charting feature to display two sets of data in a circular format. This type of chart is useful for comparing and contrasting data sets that have a similar overall total. To create a double doughnut chart, you will need to select the data sets you want to include and then insert the chart into your spreadsheet. From there, you can customize the appearance and layout of the chart to suit your needs. This feature is a useful tool for presenting data in a visually appealing and easy-to-understand manner.
Create a Double Doughnut Chart in Excel
A doughnut chart is a circular chart that uses “slices” to display the relative sizes of data. It’s similar to a pie chart except it has a hole in the center, which makes it look more like a doughnut.
A double doughnut chart is exactly what it sounds like: a doughnut chart with two layers, instead of one.
This tutorial explains how to create a double doughnut chart in Excel.
Example: Double Doughnut Chart in Excel
Perform the following steps to create a double doughnut chart in Excel.
Step 1: Enter the data.
Enter the following data into Excel, which displays the percentage of a company’s revenue that comes from four different products during two sales quarters:
Step 2: Create a doughnut chart.
Highlight the first two columns of data.
On the Data tab, in the Charts group, click the icon that says Insert Pie or Doughnut Chart.
Click on the icon that says Doughnut.
Step 3: Add a layer to create a double doughnut chart.
Right click on the doughnut chart and click Select Data.
In the new window that pops up, click Add to add a new data series.
For Series values, type in the range of values fpr Quarter 2 revenue:
Click OK. The doughnut chart will automatically update with a second outer layer:
Step 4: Modify the appearance (optional).
Once you create the double doughnut chart, you may decide to add a title and labels, and decrease the size of the hole in the middle slightly to make the chart easier to read:
Additional Resources
The following tutorials explain how to create other common visualizations in Excel: