Excel Doughnut Chart

Excel’s Doughnut Chart is a fantastic feature. It is quite useful for visualizing any statistical difference. You will learn how to make a doughnut chart with single and double data series in Excel.

This article will help you learn how to add the total value in the middle of the doughnut chart to make it more visible to others.

This article will demonstrate how to make a progress doughnut chart in Excel. The Progress Doughnut Chart displays the percentage of a task’s progress. This article also explains how to create an Excel doughnut chart containing multiple rings.

Download Practice Workbook

You can download our practice workbook from here for free!

Excel Doughnut Chart.xlsx

What Exactly Is a Doughnut Chart?

Doughnut charts show each cell’s data as a slice of doughnut. One or more doughnuts may be stacked on top of each other on the chart. Doughnut charts show the link between several types of data. Each doughnut presents a different piece of data.

What Are the Examples of Creating a Doughnut Chart in Excel?

Example 1. Making Doughnut Chart with Single Data Series

Firstly, select the dataset that you want to include in your doughnut chart.
Then, go to the Insert tab.
Now, select Insert Pie or Doughnut Chart from the Charts options.

Then, from the drop-down menu, choose Doughnut chart.

Now, you will see a doughnut chart in your worksheet.

Here, we will change the chart title.
So, double-click on the Chart Title.
Now, you can type the relevant title of the chart.

Here, we have added a Chart title named “Sales Information”.
Now, we will add data labels to your doughnut chart. Firstly, Right-click on the chart. Secondly, select Add Data Labels.

Therefore, you can see all the data have been added here. Now, we want to change the color for better visualization.
Firstly, select the chart. Then, click on the Chart Styles. After that, select Style.
Finally, you can select any chart format from there. Here, I have selected the marked format in the image below but you can select any other format you like.

Now, you can also change the color of your doughnut chart.
Select the doughnut chart. Go to Chart Styles and select Color.
Choose the color palette according to your preference. Here, we have selected the marked color Palette in the image.

Now, you may modify the doughnut’s thickness and other parameters.
Choose the doughnut chart. The right side of the screen will display the Format Data Series pane.
Here, I have kept it around 20 degrees here. To alter the doughnut chat’s thickness, alter the size of the doughnut hole. I have kept it at 50%

Finally, you can see the customized and perfect doughnut chart here in the below image.

Example 2. Making Doughnut Chart with Two Data Series

Firstly, go to the Insert tab.
Now, select Insert Pie or Doughnut Chart from the Charts options.

Then, click on the Doughnut chart option.

Here, you will see a blank chart. Now, Right click on the Doughnut chart and choose the Select Data option.

After that, click on Add.

Insert “Series name” as cell C5 and “Series values” from the C6 cell to C9 cell. Click OK.

Again, click on Add.

Insert “Series name” as cell D5 and “Series values” from the D6 cell to D9 cell. Click OK.

Now, you will see two series names. Then, click on OK and on the right-hand side, choose Edit.

After that, we will add the Axis label range from B6 cell to B9 cell. Click OK.

Again click OK.

Finally, you will get your desired doughnut with two data series values.

How to Create Doughnut Chart with Multiple Rings in Excel?

Firstly, select the dataset that you want to include in your doughnut chart. Then, go to the Insert tab.
After that, select Insert Pie or Doughnut Chart from the Charts options. Now, from the drop-down menu, choose Doughnut chart.

Now, you will see a doughnut chart in your worksheet
Here, we will change the chart title. So, click on the Chart Title. Now, you can type the relevant title of the chart.

Here, we have added a Chart title named “Sales Information”. Now, right-click on any doughnut rings and you will see the Format Data Series window.
Next, reduce the Doughnut Hole Size according to your preference for getting a better view of the chart.

Now, we will add data labels to your doughnut chart.
Next, click on the chart. Then, select the Chart Elements option. After that, choose Add Data Labels.
So, you will see all data have been shown in the chart.

You may also change the doughnut chart’s color as well.
Choose the doughnut diagram. Navigate to Chart Styles. Choose Color.
Choose the color scheme based on your personal preferences. Here, we have chosen the image’s color palette that is marked.

Finally, you will get the following doughnut chart with multiple rings.

How to Make Doughnut Chart with Total in Middle in Excel?

Firstly, select all the data.
Secondly, go to the Insert tab. Then, click on the Insert Pie or Doughnut Chart option from the ribbon. After that, choose the Doughnut chart.

Now you can see the customized doughnut chart with relevant information.

Now, we want to add the total in the middle of the doughnut chart.
Choose the appropriate value to add in the middle. I want to represent the general average value for my dataset in the center of the doughnut chart.
To determine the average, insert the following formula in the C9 cell.

=AVERAGE(C5:C8)

Press Enter to get the average value.

Next, go to the Insert tab. From the ribbon, click on the Text option. Then, choose Text Box.

Now, place the Text Box in the center of the doughnut chart.

Then, go to the formula bar. After that, write down the following formula to represent the value in the middle of the doughnut chart.

=Total_in_Middle!$C$9

Next, hit Enter.

Finally, you will get the following output.

How to Make Progress Doughnut Chart in Excel?

Here, we have calculated the remaining percentage of the assignment.
Now, insert the following formula in the C6 cell.

=100%-C5

Press Enter.

Firstly, select the dataset that you want to represent in your doughnut chart.
Then, go to the Insert tab.
After that, select Insert Pie or Doughnut Chart from the Charts options.
Now, from the drop-down menu, choose Doughnut chart.

Now, you will see a doughnut chart in your worksheet Here, we will change the chart title. So, double-click on the Chart Title.
Now, you can type the relevant title of the chart.

Here, you can see the Chart title “ Progress Doughnut Chart “. Now, you can also change the color of your doughnut chart.
Then, click on the doughnut chart. After that, go to Chart Styles. Next, choose Color.
Choose the color palette according to your preference. Here, we have selected the marked color Palette in the image.

Now, go to the Insert tab. From the ribbon, click on the Text option. Then, choose Text Box.

Now, place the Text Box in the center of the doughnut chart. Then, go to the formula bar. After that, write down the following formula to represent the progress value in the center of the doughnut chart.

=$C$5

Next, hit Enter.

Finally, you will get your output here.

Things to Remember

To access the modifying tools, you need to select the doughnut chart.
To make a doughnut chart with many rings, you should have a dataset with multiple rows and columns.
Doughnut charts are similar to pie charts and have a central hole.
Doughnut charts are useful when creating visualizations with single, double, or multiple matrices.
Making a chart for 100% matrices is often useful.
There are single-doughnut, double-doughnut, and multiple-doughnut charts available.

Conclusion

You will learn how to create an Excel doughnut chart with single, and double data series, and multiple rings. This article will show how to add total value in the middle of the doughnut chart and create a progress doughnut chart in Excel. Do you have any further queries or suggestions? If so, please let us know using the comment section below.

Frequently Asked Questions

1. In Excel, how can I make a Doughnut chart?

To make a doughnut chart in Excel, first, choose the data for the chart, then go to the Insert tab, click the “Insert Pie or Doughnut Chart” button, and then select the “Doughnut” chart type from the selections.

2. Can I change the colors of the Doughnut chart segments?

Yes, the colors of the segments in a doughnut chart can be changed. Select the chart, navigate to the Chart Tools Format tab, click the “Shape Fill” or “Shape Outline” button, and select the required color or a custom color scheme.

3. How can I add labels to the Doughnut chart segments?

To add labels to doughnut chart segments, select the chart, navigate to the Chart Tools Format tab, click the “Data Labels” button, and select the desired labeling option, such as showing the category name, value, or percentage.

4. In Excel, can I modify the size of the Doughnut chart?

In Excel, you may alter the size of the doughnut chart. Select the chart, then modify the width and height by dragging the scaling handles or entering the exact dimensions in the Format Chart Area box.