Doughnut chart is a type of chart in excel whose function of visualization is just similar to pie charts, the categories represented in this chart are parts and together they represent the whole data in the chart, only the data which are in rows or columns only can be used in creating a doughnut chart in excel, however it is advised to use this chart when we have less number of categories of data.
What is Doughnut Chart Excel?
Doughnut Chart is a part of a Pie chart in excelPie Chart In ExcelThe pie chart is a circular excel chart representing the visualization of data in a circular format. In this circular chart, every category of data has its part, and all the categories make it as a whole circular data.. PIE occupies the entire chart, but in the doughnut chart center of the slices will be cut out, and the center of the chart will be empty. Moreover, it can contain more than one data series at a time. In the PIE chart, we need to create two pie charts for two data series to compare one against the other, but doughnut makes life easy for us by allowing us to create more than one data series.
In this article, I will show you the process involved in creating a doughnut chart. Download the workbook to follow with me.
Note: I am using Excel 2013 for this article
How to Create a Doughnut Chart in Excel?
Below are the examples of the Doughnut Chart in Excel.
Example #1 – Doughnut Chart in Excel with Single Data Series
I have a simple data which shows the sales of the mobile device for the year.
We will show these numbers graphically using Doughnut Chart in Excel.
Following are the steps for creation of doughnut chart in excel using single data series –
- Select the full data range.
- Go to INSERT > Charts > PIE > Under Select Doughnut.
- Now, we have the default doughnut chart ready.
- Now, we need to modify this doughnut chart to make it beautiful to see. Select all the slices and press Ctrl + 1. It will show you the Format Data Series on the right-hand side.
- Make the angle of the first slice as 236 degrees and Doughnut Hole Size as 60%.
- Right-click on the slice and add Data Labels.
- Now select the newly inserted Data labels and press Ctrl + 1. On the right-hand side, you will see format data labels. Uncheck everything and select the only Percentage.
- Change the color of each slice to a nice color. I have changed according to my interest, and my chart looks like this.
- Add Legends to the left-hand side and make chart title as Mobile Sales Presentation.
Example #2 – Doughnut Chart in Excel with Two Data Series
We have seen how cool the Excel doughnut chart is when we compare it to the pie chart. Now we will see how we create doughnut for two data series values. For this, I have the employee’s efficiency level for the last two quarters.
Let me show you the first graphical representation in the PIE chart.
By using a PIE chart, I was forced to create two identical PIE charts because PIE can accept only one data series to its data range. If you want to see employee Q1 & Q2 efficiency level percentage, we need to look at two different charts draw conclusions; it is a herculean task to do so.
We can fit these two data series in on Excel doughnut chart only. Follow the below steps to create a doughnut chart in Excel, which includes more than one data series.
Step 1: Do not select any data but insert a blank doughnut chart.
Step 2: Right-click on the blank chart and choose Select Data.
Step 3: Now click on ADD.
Step 4: Series name as Cell B1 and Series Values as Q1 efficiency levels.
Step 5: Click on OK and again click on ADD.
Step 6: Now select second quarter values like how we have selected Q1 values.
Step 7: Click on, OK. On the right-hand side, select Edit.
Step 8: Here, select Employee Names.
Step 9: Click on the Ok. We have our default doughnut chart ready.
Step 10: Select the slice and make the Doughnut Ho0le Size as 40%. It will expand the slices.
Step 11: Change the color of each slice to a nice-looking color. You need to apply the same color for Q1 & Q2.
Step 12: Make the chart heading as Employees Q1 & Q2 Performance.
Step 13: Right Click and select Add Data Labels.
Step 14: Select the data label and add Series Name & Category Name. Note: Adjust the size of the data labels manually to make it appear cleanly.
Step 15: Select the slice, under FORMAT change the shape of the slice to Bevel > Convex. Do this for both Q1 & Q2.
Step 16: You can make changes according to your preferences. Finally, our doughnut chart is ready to rock.
Things to Remember About Doughnut Chart in Excel
- PIE can takes only one set of data; it cannot accept more than one data series.
- Limit your categories to 5 to 8. Too much is too bad for your chart.
- Easy to compare one season’s performance against another or one to many comparisons in a single chart.
- Do not add any category list; it will mess up your chart beauty.
- Always show the data label as a percentage so it can best file within the slice of the doughnut.
- You can use the empty center space of the doughnut to show many other values or calculations.
This has been a guide to Doughnut Chart in Excel. Here we discuss how to create Doughnut Chart in excel with single Data Series and Two Data Series along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –